Re: where cannot use alias name of column? - Mailing list pgsql-general

From Fernando Schapachnik
Subject Re: where cannot use alias name of column?
Date
Msg-id 20010913090928.D92584@ns1.via-net-works.net.ar
Whole thread Raw
In response to where cannot use alias name of column?  (Giorgio Volpe <giorgio.volpe@gtngroup.it>)
List pgsql-general
En un mensaje anterior, Giorgio Volpe escribió:
> May be it's my ignorance about sql ...
> but why cannot i use alias name of a column in a where clause?
>
>
> # select key as cc from mytable where cc > 0;
> ERROR:  Attribute 'cc' not found

AFAIK you can't use alias in ther where part.

Good luck!


Fernando P. Schapachnik
Planificación de red y tecnología
VIA NET.WORKS ARGENTINA S.A.
fschapachnik@vianetworks.com.ar
Tel.: (54-11) 4323-3381

pgsql-general by date:

Previous
From: "Thurstan R. McDougle"
Date:
Subject: Re: Inheritance c.cities ??
Next
From: "Thurstan R. McDougle"
Date:
Subject: Re: count of occurences PLUS optimisation