Kenneth Downs <ken(at)secdat(dot)com> writes:
> Basically, it "knows what you mean" when you do substrings on dates and
> numbers, doing an implicit cast for you.
Implicit casts to text are evil, and are mostly going to be gone in 8.3.
So try not to rely on this behavior ...
regards, tom lane