Re: ::text problem

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