[GENERAL] to pg

[Ramesh T]

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