Re: Casting

Thanks Tom,

I thought that was something you were thinking about/putting on a list to do
later. As usual the speed of fixes being given is amazing.

I'll see if I can apply it later today or tomorrow, I need to move to 7.3.2 as
well so I can try it out then.


--
Nigel J. Andrews


On Wed, 9 Apr 2003, Tom Lane wrote:
> "Nigel J. Andrews" <nandrews@investsystems.co.uk> writes:
> > mydb=> select cast('truE'::text as boolean);
> > WARNING:  Error occurred while executing PL/pgSQL function text_to_bool
> > WARNING:  line 4 at select into variables
> > ERROR:  CopyQuerySnapshot: no snapshot has been set
>
> I've applied the attached patch to fix this.
>
>             regards, tom lane
>
> *** REL7_3/src/backend/parser/parse_coerce.c.orig    Thu Oct 24 18:09:00 2002
> --- REL7_3/src/backend/parser/parse_coerce.c    Wed Apr  9 22:47:57 2003
> ***************
> *** 226,251 ****
>                   result = (Node *) makeRelabelType(result, targetTypeId, -1,