Conversion from Sybase ASA

From: "Richard Sydney-Smith" <richard(at)ibisaustralia(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Conversion from Sybase ASA
Date: 2003-09-09 07:06:40
Message-ID: 001001c376a0$ee48a8d0$f06832d2@athlon2000
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

In sybase I can use the following syntax:

select 'T' as src,(if tbon is null or tbon < '1900/12/12' or tbon > '1900/9/30' then 'U' else 'P' endif) as pres from ftrans

this returns two columns: src = 'T' and pres which has either the value 'U' or 'P'

how would I express this in postgresql?

thanks

Richard

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ian Barwick 2003-09-09 07:17:26 Re: Conversion from Sybase ASA
Previous Message Viorel Dragomir 2003-09-09 07:06:36 Re: Conversion from Sybase ASA