Postgres Pro
Downloads
Home   >   mailing lists

unique index with bool - Mailing list pgsql-general

From tmpmac@mac.com
Subject unique index with bool
Date
Msg-id 2792646.1116514167009.JavaMail.tmpmac@mac.com
Whole thread Raw
Responses Re: unique index with bool
Re: unique index with bool
Re: unique index with bool
Re: unique index with bool
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: lister
Date:
Subject: Shared memory and FreeBSD's jail()
Next
From: Stephen Aaron Knott
Date:
Subject: TSearch2 & Phonemes