Re: [GENERAL] Unique cosntraint based on contents of a field?

[Jaime Casanova]

On Wed, Apr 7, 2010 at 10:30 PM, Warren Bell <warrenbe...@gmail.com> wrote:
> 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.
>

create unique index unique_field_idx
on table1(field)
where field = 1;

-- 
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157

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