From: | Patric Bechtel <patric(dot)bechtel(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Regression in 8.3? |
Date: | 2007-11-12 13:19:21 |
Message-ID: | 473852D9.1040403@googlemail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
-----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-----
From | Date | Subject | |
---|---|---|---|
Next Message | Trevor Talbot | 2007-11-12 13:19:30 | Re: 8.2.3: Server crashes on Windows using Eclipse/Junit |
Previous Message | John DeSoi | 2007-11-12 13:15:53 | Re: Verison 8.3 PL/pgSQL debugger Question |