spikes wrote:
ansi sql compliance includes views, stored proc, tirggers, etc. odbc standards functions includes power(), space(0, cot(), truncat(),etc.
ODBC is a specification for a database API and _none_ of the DB servers complies with it as their _core_. only the DB's ODBC driver should comply with the ODBC specification (level 1,2,3).
if you'll check on the MSDN website, the ODBC function's you've mentioned doesn't exist on the ODBC specs and not even on the ODBC reserved words. and those were merely string or arithmetic functions that can be user-defined and shouldn't have a bearing for SQL compliance.
those mentioned are numeric functions that are included in the ODBC scalar function set. (e.g calling SQLGetInfo SQL_NUMERIC_FUNCTIONS)
for whatevers its worth, im just saying that it seems that mysql is more into odbc than ansi.
scalar functions http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odappepr.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odappepr_2.asp
and if you'll check on the MySQL website, you'll see that MySQL is also complying with ANSI SQL-92 standard _but_ with some extensions.
yup, they are all saying that.
NOTE: afaik, none of the DB servers strictly or 100% complies with the ANSI SQL standard.
yup, most have triggers, stored procs, etc. (postgresql 7.4 is in the house)
=)
-- Philippine Linux Users' Group (PLUG) Mailing List [EMAIL PROTECTED] (#PLUG @ irc.free.net.ph) Official Website: http://plug.linux.org.ph Searchable Archives: http://marc.free.net.ph . To leave, go to http://lists.q-linux.com/mailman/listinfo/plug . Are you a Linux newbie? To join the newbie list, go to http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie
