On Mar 4, 2012, at 14:52, Jan Meyland Andersen <jma@xxxxxxxx> wrote: > How do I return an unknown resultset from a function > > My main problem is that I do not know how many columns or the data type of the columns before runtime. > It this possible at all? > > I also tried to return the data as a text array but I also have trouble with that. > > Regards > > Jan > Try HSTORE. You can return RECORD from the function but the SQL user still has to define the names/types at design time. Text array should work but you lose column names which HSTORE maintains. You could also return a delimited string and then split it in the calling routine. David J -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
