From: [email protected] [mailto:[email protected]] On Behalf Of Ramesh T Sent: Friday, September 25, 2015 7:09 AM To: [email protected] 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
