Call Function
Functions can be used wherever expressions can appear in SPL statements. We can call a function by specifying the name of the function and the parameters in parentheses after the name.
name [ (parameters) ]
name is the name of the function. parameters is the list of actual parameters.
Note: If there are no actual parameters, the function can be called with an empty parameter list, and the parentheses after the function cannot be omitted.
The following example shows how to call a function.
select simple_function();
SIMPLE_FUNCTION
-------------------
That's All Folks!
(1 row)
The function is usually called in the SQL statement shown below.
SELECT empno "EMPNO", ename "ENAME", sal "SAL", comm "COMM",
emp_comp(sal, comm) "YEARLY COMPENSATION" FROM emp;
EMPNO | ENAME | SAL | COMM | YEARLY COMPENSATION
-------+--------+------+------+----------------------
7369 | SMITH | 800 | | 19200
7499 | ALLEN | 1600 | 300 | 45600
7521 | WARD | 1250 | 500 | 42000
7566 | JONES | 2975 | | 71400
7654 | MARTIN | 1250 | 1400 | 63600
7698 | BLAKE | 2850 | | 68400
7782 | CLARK | 2450 | | 58800
7788 | SCOTT | 3000 | | 72000
7839 | KING | 5000 | | 120000
7844 | TURNER | 1500 | 0 | 36000
7876 | ADAMS | 1100 | | 26400
7900 | JAMES | 950 | | 22800
7902 | FORD | 3000 | | 72000
7934 | MILLER | 1300 | | 31200
(14 rows)
Top comments (0)