Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125])
	by mail.postgresql.org (Postfix) with ESMTP id 2153F13C6999
	for <pgsql-sql@postgresql.org>; Fri,  4 May 2012 09:44:13 -0300 (ADT)
Received: from mailout01.ims-firmen.de ([213.174.32.96])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <andreas@a-kretschmer.de>) id 1SQHro-0000mn-1P
	for pgsql-sql@postgresql.org; Fri, 04 May 2012 12:44:13 +0000
Received: from mailin03.ims-firmen.de ([192.168.1.143])
	by mailout01.ims-firmen.de with esmtp
	(envelope-from <andreas@a-kretschmer.de>)
	id 1SQHrZ-00009v-gq; Fri, 04 May 2012 14:43:57 +0200
Received: from [213.174.32.192] (helo=oxweb02.ims-firmen.de)
	by mailin03.ims-firmen.de with esmtpsa (TLSv1:RC4-MD5:128)
	(envelope-from <andreas@a-kretschmer.de>)
	id 1SQHqA-0001VG-7b; Fri, 04 May 2012 14:42:30 +0200
Date: Fri, 4 May 2012 14:40:40 +0200 (CEST)
From: Andreas Kretschmer <andreas@a-kretschmer.de>
Reply-To: Andreas Kretschmer <andreas@a-kretschmer.de>
To: Marcel Ruff <mr@marcelruff.info>, pgsql-sql@postgresql.org
Message-ID: 
 <977719674.128861.1336135240117.JavaMail.open-xchange@ox.ims-firmen.de>
In-Reply-To: <4FA3AEA9.6010401@marcelruff.info>
References: <4FA3AEA9.6010401@marcelruff.info>
Subject: Re: How change col name during query to use it in where
 clause
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
X-Priority: 3
Importance: Medium
X-Mailer: Open-Xchange Mailer v6.20.2-Rev7
X-Pg-Spam-Score: -0.0 (/)
X-Archive-Number: 201205/6
X-Sequence-Number: 36554




Marcel Ruff <mr@marcelruff.info> hat am 4. Mai 2012 um 12:25 geschrieben:

> Hi,
>
> is an alias name not usable in the where clause?

Exactly.

Andreas