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

Reply via email to