Re: [GENERAL] unique index with bool

2005-05-24 Thread Stuart Bishop
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 [EMAIL PROTECTED] wrote: > 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(par

Re: [GENERAL] unique index with bool

2005-05-19 Thread Scott Marlowe
On Thu, 2005-05-19 at 09:49, [EMAIL PROTECTED] wrote: > 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 = 'tru

Re: [GENERAL] unique index with bool

2005-05-19 Thread Alban Hertroys
[EMAIL PROTECTED] wrote: 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. CREATE UNIQUE I

Re: [GENERAL] unique index with bool

2005-05-19 Thread Richard Huxton
[EMAIL PROTECTED] wrote: 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. Something like:

[GENERAL] unique index with bool

2005-05-19 Thread tmpmac
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 -