Re: Interesting abilities of substring

[Kenneth Downs <ken@xxxxxxxxxx>]

Tom Lane wrote:

Kenneth Downs <ken@xxxxxxxxxx> 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 ...
  

Based on general principle, or on specific bad things like unexpected or ill-defined results?

			regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
  

-- 
Kenneth Downs
Secure Data Software, Inc.
www.secdat.com    www.andromeda-project.org
631-689-7200   Fax: 631-689-0527
cell: 631-379-0010