FAQ
Hi,

Anyone knows if I can use column aliases in having condition?
Something like this.


pgdb=# select sum(c_acctbal) as p from customer having p >
1000;

select sum(c_acctbal) as p from customer having p >
1000;

ERROR: column "p" does not
exist

LINE 1: select sum(c_acctbal) as p from customer having p >
1000;

^

--
Best Regards,
Prafulla V Tekawade

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-general @
categoriespostgresql
postedJun 1, '11 at 10:08p
activeJun 1, '11 at 10:08p
posts1
users1
websitepostgresql.org
irc#postgresql

1 user in discussion

Prafulla Tekawade: 1 post

People

Translate

site design / logo © 2021 Grokbase