unique in two not so unique columns

From: "Thomas T(dot) Thai" <tom(at)minnesota(dot)com>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: unique in two not so unique columns
Date: 2002-11-02 06:58:34
Message-ID: Pine.NEB.4.43.0211020055500.15774-100000@ns01.minnesota.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2002-11-02 08:43:16 Re: unique in two not so unique columns
Previous Message Tom Lane 2002-11-02 06:01:11 Re: [GENERAL] What user to defaults execute as?