Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fBKEA1m02741 for ; Thu, 20 Dec 2001 09:10:01 -0500 (EST) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id fBKDneW24871 for pgsql-sql@postgresql.org; Thu, 20 Dec 2001 08:49:40 -0500 (EST) (envelope-from news) From: Carl van Tast X-Newsgroups: comp.databases.postgresql.sql Subject: Re: subselects Date: Thu, 20 Dec 2001 14:50:05 +0100 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 12 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: news@hub.org X-Newsreader: Forte Agent 1.8/32.548 To: pgsql-sql@postgresql.org X-Archive-Number: 200112/217 X-Sequence-Number: 6039 On Thu, 20 Dec 2001 11:07:59 +0100, "jeewee" 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 Kind regards Carl van Tast