Skip site navigation (1) Skip section navigation (2)

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

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: lockhart(at)alumni(dot)caltech(dot)edu (Thomas G(dot) Lockhart)
Cc: dschnabel(at)magnet(dot)at, hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Re: [QUESTIONS] UPDATE statement ORACLE 6 compatible
Date: 1998-03-17 03:21:53
Message-ID: 199803170321.WAA01270@candle.pha.pa.us (view raw or flat)
Thread:
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(at)candle(dot)pha(dot)pa(dot)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)

In response to

Responses

pgsql-hackers by date

Next:From: Thomas G. LockhartDate: 1998-03-17 03:46:30
Subject: Re: [HACKERS] Re: [PATCHES] patches for 6.2.1p6
Previous:From: Thomas G. LockhartDate: 1998-03-17 03:21:04
Subject: Re: [QUESTIONS] Re: [HACKERS] text should be a blob field

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group