unique index with bool

From: tmpmac(at)mac(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: unique index with bool
Date: 2005-05-19 14:49:27
Message-ID: 2792646.1116514167009.JavaMail.tmpmac@mac.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

CREATE UNIQUE INDEX name on table(param1,param2);

How to create such unique index when param2 is bool type, and this param2 should be accepted only in case of true ?

I tried: CREATE UNIQUE INDEX name on table(param1,(param2 = 'true'));
but it's not working.

Regards,
Mac

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Douglas McNaught 2005-05-19 15:10:41 Re: Shared memory and FreeBSD's jail()
Previous Message lister 2005-05-19 14:46:16 Shared memory and FreeBSD's jail()