Re: ::text problem

Thanks a lot. It worked.

----- Original Message -----
From: "Richard Huxton" <dev(at)archonet(dot)com>
To: "Kumar" <sgnerd(at)yahoo(dot)com(dot)sg>; "psql" <pgsql-sql(at)postgresql(dot)org>
Sent: Tuesday, November 25, 2003 9:44 PM
Subject: Re: [SQL] ::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