hubert depesz lubaczewski <depesz@xxxxxxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
