On the other hand, some have questioned whether there really is, in practice, a standard: <http://builder.com.com/5100-6388-1046268.html> and <http://www.tdan.com/i016hy01.htm>. (I don't mean to take sides -- I just found them interesting.)
Michael
Dave Merrill wrote:
As I said in my msg, I found out that I was wrong, '+' isn't ANSI, it's just microsoft. But mysql doesn't support the ANSI standard '||' either.
Go figure...
This is my first foray into different flavors of sql, and I'm discovering how incompatible they really are. I expected that core basics would be the same, with each manufacturer adding some proprietary extensions, and failing to support a (hopefully small) subset of standard features.
</dreaming>
Dave Merrill
At 07:37 -0500 2005/01/15, Dave Merrill wrote:
I thought string concatenation w '+' was totally standard SQL.
Hmmm, this is the first I've heard of "+" being used for concatenation (in SQL). Then again, I've never used MS SQL Server. :-)
Each language is going to have its own personality. If they all did things the same way, we wouldn't have the wealth of different ones to choose from.
Might not be a good idea, Dave, to take MS products as examples of what accepted standards are. MS has a long history of lack of respect for established standards.
I suspect MySQL is more ANSI compliant than MS SQL Server.
Rob
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
