Postgres Pro
Downloads
Home   >   mailing lists

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

From Michelle Konzack
Subject COL unique (CustomerID) plus COL unique (COUNT) inside CustomerID
Date
Msg-id 20160901092857.GC28079@cq58.hosts.tdnet.eu
Whole thread Raw
Responses Re: COL unique (CustomerID) plus COL unique (COUNT) inside CustomerID  (Szymon Lipiński <mabewlun@gmail.com>)
Re: COL unique (CustomerID) plus COL unique (COUNT) inside CustomerID  (rob stone <floriparob@gmail.com>)
Re: COL unique (CustomerID) plus COL unique (COUNT) inside CustomerID  (Andreas Kretschmer <akretschmer@spamfence.net>)
Re: COL unique (CustomerID) plus COL unique (COUNT) inside CustomerID  (Kevin Grittner <kgrittn@gmail.com>)
List pgsql-general
Tree view 
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?

Thanks in avance

--
Michelle Konzack        ITSystems
GNU/Linux Developer     0033-6-61925193

pgsql-general by date:

Previous
From: Emrul
Date:
Subject: Array element foreign keys
Next
From: Szymon Lipiński
Date:
Subject: Re: COL unique (CustomerID) plus COL unique (COUNT) inside CustomerID