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.pundt@xxxxxxxxxxxx> ---- http://rp-online.de/ ----
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
