From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Ramesh T Sent: Friday, September 25, 2015 7:09 AM To: pgsql-general@postgresql.org Subject: [GENERAL] to pg
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... CREATE UNIQUE INDEX idx_load_pick ON pick (load_id) where picked='y'; Regards, Igor Neyman