On 8 Dec 2009, at 10:36pm, Pavel Ivanov wrote:
> In brief, when you give optional expression then CASE works like
> 'switch ... case ... case ... default' construction in C, when
> optional expression is not given it works like series of 'if ... else
> if ... else' constructions in C.
Thanks Pav
On Tue, Dec 08, 2009 at 10:23:46PM +, Simon Slavin scratched on the wall:
> My Google-fu appears to be weak. SQLite apparently supports a
> CASE ... WHEN construction. Where on www.sqlite.org is the
> meaning defined ? I can see CASE mentioned in diagrams on
I'm not sure it is. I thought
Apparently document writer assumed that it's pretty obvious how CASE
works because it works the same way in all DBMSes. :)
You can read any documentation Google gives, e.g. this:
http://msdn.microsoft.com/en-us/library/ms181765.aspx.
In brief, when you give optional expression then CASE works like
My Google-fu appears to be weak. SQLite apparently supports a CASE ... WHEN
construction. Where on www.sqlite.org is the meaning defined ? I can see CASE
mentioned in diagrams on
http://www.sqlite.org/lang_expr.html
http://www.sqlite.org/syntaxdiagrams.html
but I don't understand the use of
4 matches
Mail list logo