to pg

From: Ramesh T <rameshparnanditech(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: to pg
Date: 2015-09-25 11:08:44
Message-ID: CAK8Zd=t8Q611n-6vr3Da34w-bWtZ_niq=FK23NAKSsKrKtQEQA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

  • Re: to pg at 2015-09-25 13:29:09 from Geoff Winkless
  • Re: to pg at 2015-09-25 13:33:04 from Igor Neyman
  • Re: to pg at 2015-09-25 13:44:20 from Ladislav Lenart
  • Re: to pg at 2015-09-25 13:56:56 from Albe Laurenz
  • Re: to pg at 2015-09-25 14:22:39 from Alban Hertroys

Browse pgsql-general by date

  From Date Subject
Next Message Geoff Winkless 2015-09-25 13:29:09 Re: to pg
Previous Message Steve Pritchard 2015-09-25 09:46:47 Re: Postgresql HA questions