Re: Can I CONSTRAIN a particular value to be UNIQUE? - Mailing list pgsql-sql

From G. Anthony Reina
Subject Re: Can I CONSTRAIN a particular value to be UNIQUE?
Date
Msg-id 3C069F04.50FC3BFD@nsi.edu
Whole thread Raw
In response to Re: Can I CONSTRAIN a particular value to be UNIQUE?  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-sql
Stephan Szabo wrote:

> Not really within what we provide (theoretically you could probably do
> it with a subselect in check I think). You'll probably will want to look
> at writing a plpgsql trigger to do the check.

Yes, I was hoping that something like CHECK or perhaps a RULE would work,
but it appears that the easiest way may be using an external program.

Thanks Stephan.
-Tony




pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Can I CONSTRAIN a particular value to be UNIQUE?
Next
From: "G. Anthony Reina"
Date:
Subject: Re: Can I CONSTRAIN a particular value to be UNIQUE?