Re: Conversion from Sybase ASA

Поиск
Список
Период
Сортировка
От Viorel Dragomir
Тема Re: Conversion from Sybase ASA
Дата
Msg-id 005701c376a0$ea9b5840$0600a8c0@fix.ro
обсуждение исходный текст
Ответ на Conversion from Sybase ASA  ("Richard Sydney-Smith" <richard@ibisaustralia.com>)
Список pgsql-sql
Дерево обсуждения
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 -----
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 = 'T' and pres which has either the value 'U' or 'P'

how would I express this in postgresql?

thanks

Richard

В списке pgsql-sql по дате отправления: