Re: to pg

[Geoff Winkless <pgsqladmin@xxxxxxxx>]

Surely just

CASE picked WHEN 'y' THEN load_id ELSE NULL END

or

CASE WHEN picked='y' THEN load_id ELSE NULL END

?

On 25 September 2015 at 12:08, Ramesh T <rameshparnanditech@xxxxxxxxx> wrote:

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