Postgres Pro
Downloads
Home   >   mailing lists

Unique cosntraint based on contents of a field? - Mailing list pgsql-general

From Warren Bell
Subject Unique cosntraint based on contents of a field?
Date
Msg-id 4BBD3FB4.3010206@gmail.com
Whole thread Raw
Responses Re: Unique cosntraint based on contents of a field?
List pgsql-general
Tree view 
Is there a way to create a unique constraint based on the content of a
field? For instance, say you have an integer field where you only want
one record with the number 1 in that field but there can be many records
with say the number 2 or any other single number in that field.

--
Thanks,

Warren Bell

pgsql-general by date:

Previous
From: Andy Colson
Date:
Subject: Re: Postgres 9 alpha 5 revised, stored proc
Next
From: Jaime Casanova
Date:
Subject: Re: Unique cosntraint based on contents of a field?