On Wed, Apr 24, 2013 at 12:48:44PM -0700, Stephen Scheck wrote: > I have a UDF (written in C) that returns SETOF RECORD of an anonymous > record type > (defined via OUT parameters). I'm trying to use array_agg() to transform > its output to > an array: > pg_dev=# SELECT array_agg((my_setof_record_returning_func()).col1); > ERROR: set-valued function called in context that cannot accept a set
Is there any reason why you're not using normal syntax: select array_agg(col1) from my_setof_record_returning_func(); ? Best regards, depesz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
