-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Thomas Pundt schrieb am 12.11.2007 13:18: > 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 >
Second that. A like operator is for Strings. So I was, well *cough*, surprised as it didn't. I mean it's unambiguous as it can be. Patric -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: GnuPT 2.5.2 iD8DBQFHOFNWfGgGu8y7ypARAlrdAKCUyLWH2IfIO5ckGItL8NjHBup32wCcDQmy Rqn5BtzSClTziJbjhubCm5Y= =felz -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match