| From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | "Carl van Tast" <vanTast(at)Pivot(dot)at>, <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: subselects |
| Date: | 2001-12-21 02:45:19 |
| Message-ID: | GNELIHDDFBOCMGBFGEFOMEOBCAAA.chriskl@familyhealth.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
> On Thu, 20 Dec 2001 11:07:59 +0100, "jeewee"
> <jeeweeman(at)engeenspam(dot)hotmail(dot)com> wrote:
>
> >Can anyone help me with this one, I just can't get subselects running
> >under pg, like this simple one:
> >
> >select * from (select name from users) as n;
>
> Works for me with PostgreSQL 7.1.3
Being able to select from, or join to, a SELECT was only introduced in 7.1.
In earlier versions you can use the subselect only(?) in the SELECT
parameter list, and in the where clause.
Chris
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2001-12-21 02:57:55 | Re: Transaction and cascade problem |
| Previous Message | Terrence Brannon | 2001-12-20 19:49:40 | should temporary tables show up in \dt as type "temporary" or as something? |