Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE FUNCTION sch."fn"(pArg1 CHARACTER VARYING DEFAULT 'main', pArg2 INTEGER DEFAULT 0)
- RETURNS SETOF sch."Tbl" AS
- $BODY$
- SELECT * FROM sch."Tbl" a WHERE a.arg1 = pArg1 AND a.arg2 > pArg;
- $BODY$
- LANGUAGE SQL VOLATILE
- COST 100
- ROWS 1000;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement