Re: Convert Arbitrary Table to Array? - Mailing list pgsql-general

From Tom Lane
Subject Re: Convert Arbitrary Table to Array?
Date
Msg-id 19155.1234203954@sss.pgh.pa.us
Whole thread Raw
In response to Re: Convert Arbitrary Table to Array?  (Lee Hughes <lee@hughesys.com>)
List pgsql-general
Lee Hughes <lee@hughesys.com> 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

pgsql-general by date:

Previous
From: Lee Hughes
Date:
Subject: Re: Convert Arbitrary Table to Array?
Next
From: paulo matadr
Date:
Subject: Query for describe locks