Unique cosntraint based on contents of a field?

[Warren Bell <warrenbell2@xxxxxxxxx>]

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


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general