From: | hubert depesz lubaczewski <depesz(at)depesz(dot)com> |
---|---|
To: | Patric Bechtel <patric(dot)bechtel(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Regression in 8.3? |
Date: | 2007-11-12 13:32:34 |
Message-ID: | 20071112133234.GA16618@depesz.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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?
where id % 1000 = $userinput; (for 4-digit-long-userinput)
will do the same, and at the very least will not bail out on 8.3
on the other hand. while i know and understand why there can't be "="
operator for text and int, i think that "like" could be readded as it is
really clear about how it works.
depesz
--
quicksil1er: "postgres is excellent, but like any DB it requires a
highly paid DBA. here's my CV!" :)
http://www.depesz.com/ - blog dla ciebie (i moje CV)
From | Date | Subject | |
---|---|---|---|
Next Message | Cristiano Panvel | 2007-11-12 13:42:37 | Usúario Conectados |
Previous Message | Patric Bechtel | 2007-11-12 13:21:26 | Re: Regression in 8.3? |