Re: Regression in 8.3?

hubert depesz lubaczewski <depesz(at)depesz(dot)com> writes:
> On Mon, Nov 12, 2007 at 11:26:09AM -0500, Tom Lane wrote:
>> hubert depesz lubaczewski <depesz(at)depesz(dot)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