X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id ADD439DC942 for ; Mon, 23 Jan 2006 12:36:40 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 80078-06 for ; Mon, 23 Jan 2006 12:36:38 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from wolff.to (wolff.to [66.93.197.194]) by postgresql.org (Postfix) with SMTP id 673789DC93D for ; Mon, 23 Jan 2006 12:36:36 -0400 (AST) Received: (qmail 7220 invoked by uid 500); 23 Jan 2006 16:44:06 -0000 Date: Mon, 23 Jan 2006 10:44:05 -0600 From: Bruno Wolff III To: Alexandre =?iso-8859-1?Q?Gon=E7alves_Jacarand=E1?= Cc: Tom Lane , pgsql Subject: Re: select and as doubt Message-ID: <20060123164405.GA27709@wolff.to> Mail-Followup-To: Bruno Wolff III , Alexandre =?iso-8859-1?Q?Gon=E7alves_Jacarand=E1?= , Tom Lane , pgsql References: <43C9C7B5.5070707@yahoo.com.br> <5328.1137299330@sss.pgh.pa.us> <43CA6364.6000601@yahoo.com.br> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <43CA6364.6000601@yahoo.com.br> User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.069 required=5 tests=[AWL=0.069] X-Spam-Score: 0.069 X-Spam-Level: X-Archive-Number: 200601/144 X-Sequence-Number: 23933 On Sun, Jan 15, 2006 at 12:59:48 -0200, Alexandre Gonçalves Jacarandá wrote: > Thanks for reply Tom, but which docs should I read for that ? The documentation for whatever ever programming language you will be using to generate the queries. > > Tom Lane escreveu: > > =?ISO-8859-1?Q?Alexandre_Gon=E7alves_Jacarand=E1?= writes: > > > >>It's possible to make an SELECT inside an AS clause ? > > > > > > No. You could try building the query as a string. > > > > regards, tom lane > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 5: don't forget to increase your free space map settings > > > > > -- > __________________________ > Alguns caminham pelo arco, > eu caminho pela reta. > > Alexandre Gonçalves Jacarandá > Assessor de Tecnologia de Informação > Tel.: 0 ** 21 8131-2313 > > > > > > _______________________________________________________ > Yahoo! doce lar. Faça do Yahoo! sua homepage. > http://br.yahoo.com/homepageset.html > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq