Re: Convert Arbitrary Table to Array?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Lee Hughes <lee(at)hughesys(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Convert Arbitrary Table to Array?
Date: 2009-02-09 18:25:54
Message-ID: 19155.1234203954@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Lee Hughes <lee(at)hughesys(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message SHARMILA JOTHIRAJAH 2009-02-09 19:11:56 dbi_link help
Previous Message Lee Hughes 2009-02-09 18:14:18 Re: Convert Arbitrary Table to Array?