On Tue, Dec 23, 2008 at 12:22 PM, Brian Aker <[email protected]> wrote: > Does anyone use the CASE operator? I see it for an SP, but in a SQL > statement... seems like it we be bad practice (though I think the same of > IF/ELSE in statements).
myodbc uses CASE in the query it uses to get the information out of INFORMATION_SCHEMA in the format that ODBC's SQLForeignKeys() expects. not having things like CASE/IF would mean having to actually process the data from such queries, instead of just using the result set like any other. jim _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
