::text problem

From: "Kumar" <sgnerd(at)yahoo(dot)com(dot)sg>
To: "psql" <pgsql-sql(at)postgresql(dot)org>
Subject: ::text problem
Date: 2003-11-25 12:37:58
Message-ID: 037f01c3b350$fa38ae00$7502a8c0@hdsc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi ,

I am running postgres 7.3.4 on Linux 7.2. I wanna print 'Not Supplied' if 'c1' column of datatype - 'timestamp' is null. For that I am using case statement

SELECT
CASE WHEN c1 IS NULL THEN 'Record_Not_Found'ELSE c1 END as approval_date
FROM t1;
ERROR: Bad timestamp external representation 'Record_Not_Found'

SELECT
CASE WHEN c1 IS NULL THEN 'Record_Not_Found'::text ELSE c1 END as approval_date
FROM t1;
ERROR: CASE types 'timestamp without time zone' and 'text' not matched

Where I am doing wrong? Please shed some light.

Regards
Senthil Kumar S
DBA

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2003-11-25 16:14:16 Re: ::text problem
Previous Message Kaloyan Iliev Iliev 2003-11-25 11:11:03 Unsigned numbers