Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0JFhe019675 for ; Fri, 19 Jan 2001 10:43:40 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id f0JFhLJ08519; Fri, 19 Jan 2001 10:43:21 -0500 (EST) To: "Aleksey V. Kurinov" cc: pgsql-sql@postgresql.org Subject: Re: SELECT FROM SELECT In-reply-to: <949bis$27h2$1@news.tht.net> References: <949bis$27h2$1@news.tht.net> Comments: In-reply-to "Aleksey V. Kurinov" message dated "Fri, 19 Jan 2001 15:23:31 +0300" Date: Fri, 19 Jan 2001 10:43:20 -0500 Message-ID: <8516.979919000@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200101/262 X-Sequence-Number: 931 "Aleksey V. Kurinov" writes: > Does Postrges provide "Select * from Select * from t1" construction ? In 7.1. But you have to spell it per the SQL spec: select * from (select * from t1) as foo; The parentheses and alias name are not optional. regards, tom lane