On Tuesday 25 November 2003 12:37, Kumar wrote:
>
> 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
Almost - you're on the right lines. Try:
SELECT CASE WHEN c1 IS NULL THEN 'Record_Not_Found'::text ELSE c1::text END as approval_date FROM t1;
You need to make sure both options return type text.
-- Richard Huxton Archonet Ltd
