Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE FUNCTION fb.f_users_get (
- pn_limit bigint,
- pn_offset bigint
- )
- RETURNS TABLE (
- id bigint,
- fullname varchar
- ) AS
- $body$
- begin
- return query
- select t.id,
- t.fullname
- from fb.v_users t
- limit pn_limit
- offset pn_offset;
- end;
- $body$
- LANGUAGE 'plpgsql'
- VOLATILE
- CALLED ON NULL INPUT
- SECURITY INVOKER
- COST 100 ROWS 1000;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement