Quick Links

where cannot use alias name of column?

From:	Giorgio Volpe <giorgio(dot)volpe(at)gtngroup(dot)it>
To:	Postgresql <pgsql-general(at)postgresql(dot)org>
Subject:	where cannot use alias name of column?
Date:	2001-09-13 11:25:37
Message-ID:	3BA097B1.AD659529@gtngroup.it
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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

--

Giorgio

-----------------------------------------

Responses

Re: where cannot use alias name of column? at 2001-09-13 12:09:28 from Fernando Schapachnik
Re: where cannot use alias name of column? at 2001-09-13 13:58:15 from Peter Eisentraut
Re: where cannot use alias name of column? at 2001-09-13 14:23:26 from Stephan Szabo
Re: where cannot use alias name of column? at 2001-09-13 14:23:49 from Jeff Eckermann

Browse pgsql-general by date

	From	Date	Subject
Next Message	Thurstan R. McDougle	2001-09-13 11:32:20	Re: Inheritance c.cities ??
Previous Message	R Talbot	2001-09-13 11:17:21	Re: Inheritance c.cities ??