On Thu, 2005-05-19 at 09:49, tmpmac@xxxxxxx 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. Not sure if this is what you want: create unique index on table(param1, param2) where param2 is true; ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
