NULLIF problem
| От | Gera Mel Handumon |
|---|---|
| Тема | NULLIF problem |
| Дата | |
| Msg-id | 474404120711271804y21b8e0b3j7f4b3771c088a82a@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: NULLIF problem
|
| Список | pgsql-sql |
HELLO,<br /><br />I encounter an error if i use NULLIF with timestamp with time zone.<br />eq. dbtime=nullif(mytime,'')<br/><br />i want to null the value of field DBTIME if the variable mytime=" "<br /><br />DBTIME="timestamp with time zone" datatype <br /><br />error: column DBTIME is of type timestamp with time zone but expressionis of type text.<br /><br />What should i do?<br /><br />Thanks in advance...<br clear="all" /><br />-- <br />GeraMel E. Handumon<br />Application Programmer <br />PaySoft Solutions, Inc.<br />-----------------------------------------------------------------<br/>"Share your knowledge. It's a way to achieve immortality"- Dalai Lama
В списке pgsql-sql по дате отправления: