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

В списке pgsql-general по дате отправления:

Предыдущее
От: "Paolo Saudin"
Дата:
Сообщение: SELECT to_timestamp crash PostgreSQL 9.1beta1
Следующее
От: Robert James
Дата:
Сообщение: Table with active and historical data