Re: Casting

From: "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Casting
Date: 2003-04-10 08:12:37
Message-ID: Pine.LNX.4.21.0304100910090.19529-100000@ponder.fairway2k.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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(at)investsystems(dot)co(dot)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,

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Nixon 2003-04-10 09:22:06 Re: Delete large amount of records and INSERT (with indexes) goes VERY slow
Previous Message Shridhar Daithankar 2003-04-10 06:23:22 Re: pg_dump / pg_dumpall / memory issues

Browse pgsql-hackers by date

  From Date Subject
Next Message Sailesh Krishnamurthy 2003-04-10 08:53:36 Re: Bit Filters
Previous Message Hannu Krosing 2003-04-10 07:59:42 Re: Bit Filters