hi :> i wrote function to change array to setof record, because better is working with tuples .
http://www.psycho.pl/public/src/pgsql/array.tar.bz2 i will very glade when you check this , because im afraid thed i make same mistakes .. (if its good ist could be added to contrib/array as one more funciton) its good to select like this (im writing from mem, not coping so sorry for mistakes in names) SELECT * FROM pg_catalog.pg_type t inner join pg_catalog.pg_namespace n ON (t.typnamespace=n.oid) WHERE pg_type = 'my_type' AND n.nspname IN (SELECT a FROM ( array_to_setof(current_schemas()) ) s (schema name)); declaration is setof record array_to_setof ( anyarray); i trayed created it like "any" array_to_setof( anyarray) but i had problem with select. i also trying write setof_to_array as aggregate, but i have problem with returns type , because aggregate cat have 'anyarray' as result ;( thx for your opionion. bye ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
