Re: to pg

From: Geoff Winkless <pgsqladmin(at)geoff(dot)dj>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: to pg
Date: 2015-09-25 13:29:09
Message-ID: CAEzk6fcJE89tXxGH8BaD4nZ6W+gnmO0MaP3aVwdamP-_wr1Jkw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

  • to pg at 2015-09-25 11:08:44 from Ramesh T

Browse pgsql-general by date

  From Date Subject
Next Message Igor Neyman 2015-09-25 13:33:04 Re: to pg
Previous Message Ramesh T 2015-09-25 11:08:44 to pg