Re: [SQL] Conversion from Sybase ASA

[Viorel Dragomir]

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   select 'T' as src,(CASE WHEN tbon is null or tbon < '1900/12/12' or tbon > '1900/9/30' THEN  'U' ELSE  'P' END) as pres from ftrans   I think it works in Oracle too :) Pay attention at tbon < '1900/12/12'. Try to use conversion on date formats like to_date() or to_timestamp().   Good luck ----- Original Message ----- From: Richard Sydney-Smith To: [EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 10:06 AM Subject: [SQL] Conversion from Sybase ASA 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 = '' and pres which has either the value 'U' or 'P' how would I express this in postgresql? thanks Richard