-----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
