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? |