-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Karsten Hilbert schrieb am 12.11.2007 13:07:
> 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
Just guess: We have bigint id's through the system, so I want to give
the users the convenience of typing only the last 4-5 digits (which most
of the time is enough). So the query we issue really is
... like "%$userinput"
Makes sense, or?
Patric
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: GnuPT 2.5.2
iD8DBQFHOFLZfGgGu8y7ypARAn0sAJ968gHCSICQtHH6ZkNHCXbvR2fTvACg6pU4
Bf9HiTiyB5UEvLbun4kGARs=
=YbyY
-----END PGP SIGNATURE-----
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
