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