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

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

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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Interesting abilities of substring
Next
From: Tom Lane
Date:
Subject: Re: Bytea question with \208