On Sat, 15 Jan 2005 11:37:02 -0500, Dave Merrill wrote: > > 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.
DBMS's are slowly getting there. What you are (I am) seeing is that whenever vendors introduce new features that are in the standard, they follow the syntax from the standard. Yukon will have SQL standard recursive queries, MySQL will have a standard implementation of SQL-PSM, PostgreSQL got a standard information schema etc. It is not going as fast as I would like and vendors are especially reluctant to rewrite existing features to use standard syntax (in casu MySQL and the horrible overloading off timestamp behaviours), but it isn't that long ago that we wouldn't even consider outer join syntax as standard. Jochem -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
