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 581219DDBBE for ; Sun, 15 Jan 2006 11:00:32 -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 90652-08 for ; Sun, 15 Jan 2006 11:00:36 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp204.mail.sc5.yahoo.com (smtp204.mail.sc5.yahoo.com [216.136.130.127]) by postgresql.org (Postfix) with SMTP id 8D4579DDAB2 for ; Sun, 15 Jan 2006 11:00:28 -0400 (AST) Received: (qmail 62145 invoked from network); 15 Jan 2006 15:00:32 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.br; h=Received:Message-ID:Date:From:User-Agent:X-Accept-Language:MIME-Version:To:CC:Subject:References:In-Reply-To:Content-Type:Content-Transfer-Encoding; b=5BkZnY3FFoXP9jY3x4X4nU6zkTa4Dl5hqDp2RZxHpkTipgwt/AiLqUm7SYU06c4Y4FjtIvb+CRtsaE735cElMOJ/+z6INa2fcwIxRYlLtlyneBA2l0rhFiWo3eszCnMGO8dWfI/+IEUqk8Ei3AfpVRB/ew3LBR5ioWMzxqJqvJQ= ; Received: from unknown (HELO ?200.141.96.26?) (clark?vr@200.141.96.26 with plain) by smtp204.mail.sc5.yahoo.com with SMTP; 15 Jan 2006 15:00:31 -0000 Message-ID: <43CA6364.6000601@yahoo.com.br> Date: Sun, 15 Jan 2006 12:59:48 -0200 From: =?ISO-8859-1?Q?Alexandre_Gon=E7alves_Jacarand=E1?= User-Agent: Mozilla Thunderbird 1.0.6-7.2.20060mdk (X11/20050322) X-Accept-Language: pt-br, pt MIME-Version: 1.0 To: Tom Lane CC: pgsql Subject: Re: select and as doubt References: <43C9C7B5.5070707@yahoo.com.br> <5328.1137299330@sss.pgh.pa.us> In-Reply-To: <5328.1137299330@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.479 required=5 tests=[DNS_FROM_RFC_ABUSE=0.479] X-Spam-Score: 0.479 X-Spam-Level: X-Archive-Number: 200601/77 X-Sequence-Number: 23866 Thanks for reply Tom, but which docs should I read for that ? 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