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 <[EMAIL PROTECTED]> http://svana.org/kleptog/ > Those who make peaceful revolution impossible will make violent revolution > inevitable. > -- John F Kennedy
signature.asc
Description: Digital signature