héhé,
nice snipping Merlin !
I guess you are almost there, output is still wrong (should be) (
> 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
> D,1; A,2; D,2; B,1; C,2
)
I don't understand enough to make the modifications =)
I don't understand enough to make the modifications =)
Cheers,
Rémi-C
2013/10/22 hubert depesz lubaczewski <depesz@xxxxxxxxxx>
On pon, paź 21, 2013 at 08:38:52 -0400, Robert James wrote:"A" or other letters don't really match your schema description.
> 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?
Please provide sample schema (as in: create table ...), sample data, and
expected output.
Best regards,
depesz
--
The best thing about modern society is how easy it is to avoid contact with it.
http://depesz.com/
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
