Michelle Konzack <linux4miche...@gmail.com> wrote: > Hello to all, > > after a period of silence from Debian, Courier, PHP and PostgreSQL I am > half back and running into a problem... :-/ > > I need a table with an UNIQUE CustomerID which is working fine... > > ...BUT I need also a second column with a count, which must be UNIQUE > inside the CustomerID. > > In clear this: > > CustID Count > 1 1 > 1 2 > 1 3 > > 2 1 > 2 2 > > 3 1 > 3 2 > 3 3 > ... > > How to do this?
don't store the Count-column and using row_number() over (partition by CustId) instead? Btw.: Greetings, how are you? ;-) Regards, Andreas Kretschmer -- Andreas Kretschmer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general