[snip] > Anyhow, it has been a good discussion. No bugs were uprooted and > everyone's understanding may have risen a notch. After a couple of > decades using SQL I still find interesting topics to discuss.
Yes, I too have enjoyed this conversation. Thank you for thinking out loud with me on such an important topic. I have one last pitch to make, though, so I don't think you are quite off the hook yet. ;-) I went looking and found a nearly finished copy of the SQL-2003 spec (but not the official one) at http://www.wiscorp.com/sql/sql_2003_standard.zip (subfile: 5WD-02-Foundation-2003-09.pdf). I can't imagine the final draft changing too much from what I quote below. [/snip] Most manufacturers are using ANSI SQL 99 IIRC (ymmv) which is available from ANSI (http://www.ansi.org) for a small fee. It generally takes a few years for standards to become implemented by mfgs. I think that you may be confusing search conditionals and equation operations too... WHERE foo <= bar is a search condition IF(t1.foo=t2.bar, 2, 1) is an equation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
