Advertisement
joshuaboshi

Untitled

Aug 26th, 2011
143
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.26 KB | None | 0 0
  1. CREATE OR REPLACE FUNCTION sch."fn"(pArg1 CHARACTER VARYING DEFAULT 'main', pArg2 INTEGER DEFAULT 0)
  2.   RETURNS SETOF sch."Tbl" AS
  3. $BODY$
  4. SELECT * FROM sch."Tbl" a WHERE a.arg1 = pArg1 AND a.arg2 > pArg;
  5. $BODY$
  6.   LANGUAGE SQL VOLATILE
  7.   COST 100
  8.   ROWS 1000;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement