Home > mailing lists

Re: to pg - Mailing list pgsql-general

From	Geoff Winkless
Subject	Re: to pg
Date	September 25, 2015 16:29:30
Msg-id	CAEzk6fcJE89tXxGH8BaD4nZ6W+gnmO0MaP3aVwdamP-_wr1Jkw@mail.gmail.com Whole thread Raw
In response to	to pg (Ramesh T <rameshparnanditech@gmail.com>)
List	pgsql-general

Tree view

Surely just

CASE picked WHEN 'y' THEN load_id ELSE NULL END

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

On 25 September 2015 at 12:08, Ramesh T <rameshparnanditech@gmail.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...

pgsql-general by date:

From: Ramesh T
Date: 25 September 2015, 16:25:54
Subject: to pg

From: Ladislav Lenart
Date: 25 September 2015, 16:44:29
Subject: Re: to pg

Re: to pg - Mailing list pgsql-general

Previous

Next