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 |