> I suspect that the main thing that will cause issues is removal of > implicit coercions to text. For example, in 7.2 and before you can do > > test72=# select 'At the tone, the time will be ' || now(); > ?column? > ------------------------------------------------------------- > At the tone, the time will be 2002-04-11 11:49:27.309181-04 > (1 row)
I have seen this coding practice extremely often and would be very unhappy if it were not allowed any more. Imho automatic coercions are a good thing and should be done where possible. Other extensible databases also allow this without a cast. Imho the main culprit is finding a "number" format that will not loose precision when implicitly propagated to. Andreas ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])