Re: Can I CONSTRAIN a particular value to be UNIQUE?

From: "G(dot) Anthony Reina" <reina(at)nsi(dot)edu>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Can I CONSTRAIN a particular value to be UNIQUE?
Date: 2001-11-29 20:48:04
Message-ID: 3C069F04.50FC3BFD@nsi.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message G. Anthony Reina 2001-11-29 21:05:48 Re: Can I CONSTRAIN a particular value to be UNIQUE?
Previous Message Tom Lane 2001-11-29 20:38:20 Re: Can I CONSTRAIN a particular value to be UNIQUE?