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...