On Tuesday 09 September 2003 09:06, Richard Sydney-Smith wrote:
> 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 e
;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:
Ri
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
