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@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026