RETURNS SETOF NUMERIC AS
$$
SELECT empno FROM emp WHERE ename LIKE $1;
$$
LANGUAGE 'sql' STABLE;
| pgsql_func_stable1 |
| CREATE OR REPLACE FUNCTION get_empno1(name varchar) RETURNS SETOF NUMERIC AS $$ SELECT empno FROM emp WHERE ename LIKE $1; $$ LANGUAGE 'sql' STABLE;
|
| EMP Table :
|
|