Re: Interesting abilities of substring - Mailing list pgsql-general

From Tom Lane
Subject Re: Interesting abilities of substring
Date
Msg-id 17410.1186680297@sss.pgh.pa.us
Whole thread Raw
In response to Interesting abilities of substring  (Kenneth Downs <ken@secdat.com>)
Responses Re: Interesting abilities of substring  (Kenneth Downs <ken@secdat.com>)
List pgsql-general
Kenneth Downs <ken@secdat.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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: failed to unlink, Permission denied
Next
From: Kenneth Downs
Date:
Subject: Re: Interesting abilities of substring