Home > mailing lists

Column aliases in having or where for Postgres 8.3 - Mailing list pgsql-general

From	Prafulla Tekawade
Subject	Column aliases in having or where for Postgres 8.3
Date	June 1, 2011 22:08:35
Msg-id	BANLkTimcU33BmY0WqfAVOA0FbD=BV7XtcA@mail.gmail.com Whole thread Raw
List	pgsql-general

Tree view

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

pgsql-general by date:

From: "Paolo Saudin"
Date: 01 June 2011, 19:15:52
Subject: SELECT to_timestamp crash PostgreSQL 9.1beta1

From: Robert James
Date: 01 June 2011, 23:30:22
Subject: Table with active and historical data

Column aliases in having or where for Postgres 8.3 - Mailing list pgsql-general

Previous

Next