hubert depesz lubaczewski <depesz@depesz.com> writes:
> On Mon, Nov 12, 2007 at 11:26:09AM -0500, Tom Lane wrote:
>> hubert depesz lubaczewski <depesz@depesz.com> writes:
>>> 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.
>> Really?
> yes. i still hold my opinion: *int* like *text* is clear.
regression=# select '00123'::text like '0%';
?column?
----------
t
(1 row)
regression=# select '00123'::int4 like '0%';
?column?
----------
f
(1 row)
regards, tom lane