NULLIF problem - Mailing list pgsql-sql

From Gera Mel Handumon
Subject NULLIF problem
Date
Msg-id 474404120711271804y21b8e0b3j7f4b3771c088a82a@mail.gmail.com
Whole thread Raw
Responses Re: NULLIF problem
List 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 by date:

Previous
From: "Daniel Caune"
Date:
Subject: Strang behaviour SELECT ... LIMIT n FOR UPDATE
Next
From: Michael Glaesemann
Date:
Subject: Re: NULLIF problem