Hi!
How can I refer the calculated field in HAVING clause.
This work in MySQL:
SELECT some_expression as field1, ...
FROM tablename
GROUP BY ...
HAVING field1>0;
PostgreSQL gives error "Attribute 'field1' not found".
Are there any workarounds?
Thanks.
--
Alexander Barkov
IZHCOM, Izhevsk
email: bar@izhcom.ru | http://www.izhcom.ru
Phone: +7 (3412) 51-55-45 | Fax: +7 (3412) 78-70-10
ICQ: 7748759