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 <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? > > Thanks in avance > > -- > Michelle Konzack ITSystems > GNU/Linux Developer 0033-6-61925193 > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
