On Mon, Nov 12, 2007 at 02:46:50PM +0100, Karsten Hilbert wrote:
> 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.
If people want it they can add the automatic cast back in, it just
isn't dfault anymore.
Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
> -- John F Kennedy