Received: from nsi.edu (amethea.nsi.edu [198.133.185.9]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fATKZDm27190 for ; Thu, 29 Nov 2001 15:35:13 -0500 (EST) (envelope-from reina@nsi.edu) Received: from nsi.edu (nsi.edu [198.133.185.9]) by nsi.edu (8.9.1/8.9.1) with ESMTP id MAA26857; Thu, 29 Nov 2001 12:35:09 -0800 (PST) Message-ID: <3C069F04.50FC3BFD@nsi.edu> Date: Thu, 29 Nov 2001 12:48:04 -0800 From: "G. Anthony Reina" Organization: The Neurosciences Institute X-Mailer: Mozilla 4.75C-SGI [en] (X11; I; IRIX 6.5 IP32) X-Accept-Language: en MIME-Version: 1.0 To: Stephan Szabo CC: pgsql-sql@postgresql.org Subject: Re: Can I CONSTRAIN a particular value to be UNIQUE? References: <20011129115442.X45413-100000@megazone23.bigpanda.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200111/418 X-Sequence-Number: 5800 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