Re: COL unique (CustomerID) plus COL unique (COUNT) inside CustomerID - Mailing list pgsql-general

Michelle Konzack <linux4michelle@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