Re: [GENERAL] COL unique (CustomerID) plus COL unique (COUNT) inside CustomerID

2016-09-01 Thread Kevin Grittner
On Thu, Sep 1, 2016 at 4:28 AM, Michelle Konzack wrote: > 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. Just to be clear, you probably have a

Re: [GENERAL] COL unique (CustomerID) plus COL unique (COUNT) inside CustomerID

2016-09-01 Thread Andreas Kretschmer
Michelle Konzack 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

Re: [GENERAL] COL unique (CustomerID) plus COL unique (COUNT) inside CustomerID

2016-09-01 Thread rob stone
On Thu, 2016-09-01 at 12:28 +0300, Michelle Konzack 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

Re: [GENERAL] COL unique (CustomerID) plus COL unique (COUNT) inside CustomerID

2016-09-01 Thread Szymon Lipiński
Hi, you can use the UNIQUE constraint with two columns: UNIQUE(CustID, Count). regards, Szymon Lipiński On 1 September 2016 at 11:28, Michelle Konzack wrote: > Hello to all, > > after a period of silence from Debian, Courier, PHP and PostgreSQL I am > half back and

[GENERAL] COL unique (CustomerID) plus COL unique (COUNT) inside CustomerID

2016-09-01 Thread Michelle Konzack
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.