[SQL] ::text problem

[Kumar]

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