Hi Ann, all, On Tue, Dec 23, 2008 at 11:42 PM, Ann W. Harrison <[email protected]> wrote: > Brian Aker wrote: >> > There are two CASE thingies in MySQL - the CASE expression which appears > to follow SQL standard syntax and semantics and the CASE statement which > does not, but is used only in stored procedures. The CASE expression
Actually - both forms are standard (1999 and 2003) sql. The case expression is defined in book 2, "foundation" and the case statement is defined in book 4, "persistent stored modules" kind regards, Roland > shouldn't make applications less portable because it is pretty widely > implemented, and generally implementations follow the standards syntax. > > Stored procedures and portability are another story. > > So my preference would be to keep at least the CASE expression. > > > Best, > > Ann > > > _______________________________________________ > Mailing list: https://launchpad.net/~drizzle-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~drizzle-discuss > More help : https://help.launchpad.net/ListHelp > -- Roland Bouman http://rpbouman.blogspot.com/ _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
