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.
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346