Re: [QUESTIONS] UPDATE statement ORACLE 6 compatible

From: "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu>
To: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
Cc: Dietmar Schnabel <dschnabel(at)magnet(dot)at>, Postgres Hackers List <hackers(at)postgresql(dot)org>
Subject: Re: [QUESTIONS] UPDATE statement ORACLE 6 compatible
Date: 1998-03-17 02:52:04
Message-ID: 350DE554.D8C38D6@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> > I am not absolutly happy with this because it looks like the
> > statement is not working correctly for 100%. It comes back with an
> > strange error message if the '%' sign is at the end of '40'!!..
> >
> > select * from my_table where cast(my_int as text) like '40%';
> > ERROR: transformExpr: does not know how to transform node 103
> >
> > Any ideas!..
> Thomas, I believe this is the problem with my processing a node twice.
> Do you have a fix for that, or should I make one?

tgl=> select * from t where cast(i as text) like '40%';
i
----
4030
(1 row)

So, the patch for "function() BETWEEN" helps, but I'm still not sure it
is safe, since I don't know how these nodes might be handled deeper in
the backend.

Also, one of my recent testing patches slightly breaks the type
conversion stuff so the numerology regression test fails on one of the
inserts and I haven't figured out which piece caused that. Nothing
should be affected in the CVS tree though.

- Tom

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1998-03-17 03:02:49 Re: [HACKERS] Unique index using hash?
Previous Message The Hermit Hacker 1998-03-17 02:47:57 Re: [HACKERS] Re: [PATCHES] patches for 6.2.1p6