Re: [HACKERS] Re: [QUESTIONS] UPDATE statement ORACLE 6 compatible

Bruce Momjian <maillist@candle.pha.pa.us>

From: Bruce Momjian <maillist@candle.pha.pa.us>
To: lockhart@alumni.caltech.edu (Thomas G. Lockhart)
Cc: dschnabel@magnet.at, hackers@postgreSQL.org
Date: 1998-03-17T03:21:53Z
Lists: pgsql-hackers
> 
> 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.

Ship the patch over here and I will have a look at it.

-- 
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)