From: Gera Mel Handumon <geramel.h@gmail.com>
To: pgsql-sql@postgresql.org
Subject: NULLIF problem
Date: Wed, 28 Nov 2007 10:04:47 +0800
Message-ID: <474404120711271804y21b8e0b3j7f4b3771c088a82a@mail.gmail.com> (raw)
HELLO,
I encounter an error if i use NULLIF with timestamp with time zone.
eq. dbtime=nullif(mytime,'')
i want to null the value of field DBTIME if the variable mytime=" "
DBTIME ="timestamp with time zone" datatype
error: column DBTIME is of type timestamp with time zone but expression is
of type text.
What should i do?
Thanks in advance...
--
Gera Mel E. Handumon
Application Programmer
PaySoft Solutions, Inc.
-----------------------------------------------------------------
"Share your knowledge. It's a way to achieve immortality" - Dalai Lama
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: geramel.h@gmail.com
Subject: Re: NULLIF problem
In-Reply-To: <474404120711271804y21b8e0b3j7f4b3771c088a82a@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox