Re: Regression in 8.3?

Hi,

On Montag, 12. November 2007, Karsten Hilbert wrote:
| On Mon, Nov 12, 2007 at 12:46:58AM +0100, Patric Bechtel wrote:
| > select * from bla where a like '8%'
|
| Patrick, I'm not sure what you expect to come back:
|
| 8 ? 0.08 ?
|
| 8% of each of bla.a's values ?
|
| do 7% or 9% count, too ? ("a like '8%'" seems to say "well,
| about 8% of a, or close, anyways").
|
| IOW, it is not entirely clear and thus the server forces us
| to make a choice and not second-guess our intentions.

The %-sign in conjunction with a "like" operator in a string doesn't
leave much room for interpretation IMO, regardless if the "a" column
is of type "bigint" or not.

Ciao,
Thomas

--
Thomas Pundt <thomas(dot)pundt(at)rp-online(dot)de> ---- http://rp-online.de/ ----