Postgres Pro
Downloads
Home   >   mailing lists

Re: using 'count' to show number of dupes - Mailing list pgsql-novice

From Andy Harrison
Subject Re: using 'count' to show number of dupes
Date
Msg-id a22ff29404071211026105527d@mail.gmail.com
Whole thread Raw
In response to Re: using 'count' to show number of dupes  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-novice
Tree view 
On Mon, 12 Jul 2004 10:39:00 -0700 (PDT), Stephan Szabo
<sszabo@megazone.bigpanda.com> wrote:
>
> Something like:
> select col2, count(*) from table group by col2;
>

Great, thanx.  That got me on the right road.  Fast too.  Several mere
seconds for 1.25M rows.

--
Andy Harrison

pgsql-novice by date:

Previous
From: "Loftis, Charles E"
Date:
Subject: Re: using 'count' to show number of dupes
Next
From: Ralf Hasemann
Date:
Subject: plpgsql functing does not use index....