Re: [GENERAL] HAVING QUESTION

[Charset koi8-r unsupported, filtering to ASCII...]
>
> 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".

Worked here in development tree:

select state as test, count(*)
from friends
group by test
having count(*) > 1\g

test|count
----+-----
MA | 2
NJ | 2
(2 rows)

I think your problem is that field1 is not an aggregate or if it is, you
may need to repeat the aggregate in the having.

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026