Advertisement
Guest User

Untitled

a guest
Oct 13th, 2017
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE OR REPLACE FUNCTION fb.f_users_get (
  2.   pn_limit bigint,
  3.   pn_offset bigint
  4. )
  5. RETURNS TABLE (
  6.   id bigint,
  7.   fullname varchar
  8. ) AS
  9. $body$
  10. begin
  11.   return query
  12.     select t.id,
  13.            t.fullname
  14.       from fb.v_users t
  15.      limit pn_limit
  16.     offset pn_offset;
  17. end;
  18. $body$
  19. LANGUAGE 'plpgsql'
  20. VOLATILE
  21. CALLED ON NULL INPUT
  22. SECURITY INVOKER
  23. COST 100 ROWS 1000;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement