Column aliases in having or where for Postgres 8.3
| От | Prafulla Tekawade |
|---|---|
| Тема | Column aliases in having or where for Postgres 8.3 |
| Дата | |
| Msg-id | BANLkTimcU33BmY0WqfAVOA0FbD=BV7XtcA@mail.gmail.com обсуждение исходный текст |
| Список | pgsql-general |
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
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 по дате отправления: