Re: to pg

[Igor Neyman <ineyman@xxxxxxxxxxxxxx>]

 

 

From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Ramesh T
Sent: Friday, September 25, 2015 7:09 AM
To: pgsql-general@xxxxxxxxxxxxxx
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