Postgres Pro
Downloads
Home   >   mailing lists

Count of records in a row - Mailing list pgsql-general

From Robert James
Subject Count of records in a row
Date
Msg-id CAGYyBghMhBve35jmjv1X7Ga+g-Ry7hDr+C3h8uid3CqOSFR04w@mail.gmail.com
Whole thread Raw
Responses Re: Count of records in a row  (David Johnston <polobo@yahoo.com>)
Re: Count of records in a row  (hubert depesz lubaczewski <depesz@depesz.com>)
Re: Count of records in a row  (Elliot <yields.falsehood@gmail.com>)
List pgsql-general
Tree view 
I have a table of event_id, event_time.  Many times, several events
happen in a row.  I'd like a query which replaces all of those events
with a single record, showing the count.

Eg: Take A,A,A,B,C,A,D,A,A,D,D,B,C,C and return: A,3; B,1; C,1; A,1;
D,1; A,2; D,2; B,1; C,2

How can I do that?

pgsql-general by date:

Previous
From: David Johnston
Date:
Subject: Re: Bug? Function with side effects not evaluated in CTE
Next
From: David Johnston
Date:
Subject: Re: Count of records in a row