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.
[EMAIL PROTECTED]
Tel.: (54-11) 4323-3381
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
