Lee Hughes <lee@xxxxxxxxxxxx> writes: > Good point on scalability -- I am planning to limit the number of rows > fetched through LIMIT or a Cursor once I have the basics working. Er ... why don't you just use a cursor directly on the table? > Did you mean *select array(select * from mytable);* ? No, I meant what I wrote --- * won't work, you need a single composite column coming out of the inner select. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general