Re: Regression in 8.3?

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?

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