Consider the following Extrapolate functions and the corresponding specific name as specified in the SPECIFIC clause of CREATE FUNCTION.
| Function Name and Parameters | Specific Name |
|---|---|
| Extrapolate(a INTEGER, b INTEGER, c INTEGER) | S1 |
| Extrapolate(a VARCHAR(20), b VARCHAR(20), c VARCHAR(20)) | S2 |
The results of calling the function with NULL as a literal argument appears in the following table.
| Function Invocation | What Vantage Does |
|---|---|
SELECT Extrapolate(3, NULL, 9); |
Invokes function name with specific name S1. |
SELECT Extrapolate('Ver', NULL, '*.*');
|
Invokes function name with specific name S2. |
SELECT Extrapolate(NULL, NULL, NULL); |
Returns error. |
SELECT Extrapolate(CAST(NULL AS INTEGER), NULL, NULL); |
Invokes function name with specific name S1. |