Postgres Pro
Downloads
Home   >   mailing lists

unique in two not so unique columns - Mailing list pgsql-general

From Thomas T. Thai
Subject unique in two not so unique columns
Date
Msg-id Pine.NEB.4.43.0211020055500.15774-100000@ns01.minnesota.com
Whole thread Raw
Responses Re: unique in two not so unique columns
Re: unique in two not so unique columns
List pgsql-general
Tree view 
I have two columns in a table:

email     varchar(64)
verified  boolean

How do I make a check for unique email that is verified while allowing for
non-verified emails to be not unique?

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pg_restore error
Next
From: Martijn van Oosterhout
Date:
Subject: Re: unique in two not so unique columns