Re: Regression in 8.3? - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: Regression in 8.3?
Date
Msg-id 20071112134650.GC4458@merkur.hilbert.loc
Whole thread Raw
In response to Re: Regression in 8.3?  (Patric Bechtel <patric.bechtel@gmail.com>)
Responses Re: Regression in 8.3?  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
On Mon, Nov 12, 2007 at 02:19:21PM +0100, Patric Bechtel wrote:

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

It surely makes sense - in your environment - but it's not
the only interpretation so PG tries to be impartial and
makes both of us say clearly what we want.

Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

pgsql-general by date:

Previous
From: Lars Haugseth
Date:
Subject: Re: Duplicating a table row while honouring key constraints
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Regression in 8.3?