Hi, > That is certainly not going to work: that select does not produce an > array, it produces a column of user_t (of which SELECT INTO is only > gonna take the first, anyway). > > Untested, but I think you'd have better results with > > _page.users := array(select users from users limit 10);
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'? Best regards, Jon -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general