Re: Regression in 8.3?

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?

regression=# select '8.12345678901234567890' ~~ '%67890' ;
 ?column?
----------
 t
(1 row)

regression=# select '8.12345678901234567890'::numeric ~~ '%67890' ;
 ?column?
----------
 t
(1 row)

regression=# select '8.12345678901234567890'::float8 ~~ '%67890' ;
 ?column?
----------
 f
(1 row)

regression=# select '8.12345678901234567890'::char(50) ~~ '%67890' ;
 ?column?
----------
 f
(1 row)

Yup, the behavior of LIKE before 8.3 was just as datatype-independent
as could be.

            regards, tom lane