Advertisement
joshuaboshi

Untitled

Sep 2nd, 2011
187
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE or replace FUNCTION base."getTypes"(IN "pSchema" character varying) RETURNS SETOF pg_type AS
  2. $BODY$
  3. SELECT
  4.     --pg_type.oid,
  5.     pg_type.*
  6.    
  7. FROM pg_type
  8. JOIN pg_namespace ON typnamespace = pg_namespace.oid
  9. WHERE
  10.     nspname = $1
  11. ;$BODY$
  12. LANGUAGE sql VOLATILE;
  13.  
  14. select * from base."getTypes"('schema');
  15.  
  16. -- how to get oid of result row from this function???
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement