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(at)gmail(dot)com>
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...
>