2011/1/13 Alban Hertroys <dalroi@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>: > On 13 Jan 2011, at 19:25, Pavel Stehule wrote: > >>> The above does work, thanks. ÂThere is however one drawback: the type >>> associated with _page.users is now an array. ÂIs there a way to make >>> it a 'SETOF user_t'? >>> >> >> no. PostgreSQL doesn't supports SET. Only arrays are supported. > > > I'm not sure what you mean here, Postgres certainly _does_ support set-returning functions. Maybe you were referring to something in the particular context of the problem the OP is trying to solve? > The name of feature "SET RETURNED FUNC" doesn't mean so PostgreSQL supports SET type in ANSI SQL sense. Regards Pavel Stehule > It would be kind of bad if people Google for this topic and would come back with the wrong conclusion. > > Alban Hertroys > > -- > Screwing up is an excellent way to attach something to the ceiling. > > > !DSPAM:1030,4d2f4de011871371264419! > > > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
