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

From Andreas Kretschmer
Subject Re: COL unique (CustomerID) plus COL unique (COUNT) inside CustomerID
Date
Msg-id 20160901140122.GA9569@tux
Whole thread Raw
In response to COL unique (CustomerID) plus COL unique (COUNT) inside CustomerID  (Michelle Konzack <linux4michelle@gmail.com>)
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


pgsql-general by date:

Previous
From: rob stone
Date:
Subject: Re: COL unique (CustomerID) plus COL unique (COUNT) inside CustomerID
Next
From: "dandl"
Date:
Subject: Re: UPDATE OR REPLACE?