Home > mailing lists

Conversion from Sybase ASA - Mailing list pgsql-sql

From	Richard Sydney-Smith
Subject	Conversion from Sybase ASA
Date	September 9, 2003 07:05:27
Msg-id	001001c376a0$ee48a8d0$f06832d2@athlon2000 Whole thread Raw
Responses	Re: Conversion from Sybase ASA (Ian Barwick <barwick@gmx.net>)
List	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

From: Achilleus Mantzios
Date: 09 September 2003, 06:54:55
Subject: Re: undefine currval()

From: "Viorel Dragomir"
Date: 09 September 2003, 07:09:44
Subject: Re: Conversion from Sybase ASA