Re: COL unique (CustomerID) plus COL unique (COUNT) inside CustomerID

Michelle Konzack <linux4michelle(at)gmail(dot)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