Select .. Having vs computer fields

From: Francisco Reyes <lists(at)natserv(dot)com>
To: pgsql General List <pgsql-general(at)postgresql(dot)org>
Subject: Select .. Having vs computer fields
Date: 2001-12-12 17:54:32
Message-ID: 20011212124744.T40466-100000@zoraida.natserv.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Can use use computed fields on the "having" part of select?
I have tried:
select a,b, count(*) as dups_count from some_table having dups_count > 1;

and it gives me the error "Attribute 'dups_count' not found"

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Philip Rhoades 2001-12-12 17:54:47 Functions like: GetNextRecord . .
Previous Message Tom Lane 2001-12-12 17:53:57 Re: [GENERAL] Using Cursor in PostgreSQL 7.2