Surely just CASE picked WHEN 'y' THEN load_id ELSE NULL END
or CASE WHEN picked='y' THEN load_id ELSE NULL END ? On 25 September 2015 at 12:08, Ramesh T <rameshparnandit...@gmail.com> wrote: > CREATE UNIQUE INDEX idx_load_pick ON pick (case picked when picked='y' > then load_id else null end ); > > how can i convert case expressed to postgres..above it is oracle. > > any help appreciated... >