Roland Bouman wrote:
Hi Brian, all,
The implicit conversion is what allows "3" + 3 to work. I've always thought
that was good... on the other hand it can not currently tell is "3 o'clock"
+ 4 is valid or not (IMHO it should not be).
I don't think it is possible to lay down any standard result. I could argue that
'3' + 3 == 6
just as well as
'3' + 3 == '33'
I don't see why either of these interpretations would be better than the other.
As always, the SQL standard is more explicit and consistent: 3 +
cast('3' as integer) - with an exception from the cast if the string
cannot be converted to an integer.
Roy
Cheers,
-Brian
--
_______________________________________________________
Brian "Krow" Aker, brian at tangent.org
Seattle, Washington
http://krow.net/ <-- Me
http://tangent.org/ <-- Software
_______________________________________________________
You can't grep a dead tree.
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
