From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@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';