db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Christian d'Heureuse (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-1575) document full syntax of CASE expression
Date Sun, 23 Jul 2006 12:34:14 GMT
document full syntax of CASE expression
---------------------------------------

                 Key: DERBY-1575
                 URL: http://issues.apache.org/jira/browse/DERBY-1575
             Project: Derby
          Issue Type: Improvement
          Components: Documentation
            Reporter: Christian d'Heureuse


The documentation at http://db.apache.org/derby/docs/dev/ref/rrefcasenullif.html describes
the CASE expression syntax as:

   CASE WHEN BooleanExpression THEN thenExpression ELSE elseExpression END

But the CASE expression supports more than one WHEN/THEN clauses.
I suggest to change the syntax description to:

   CASE
      WHEN BooleanExpression THEN Expression
    [ WHEN BooleanExpression THEN Expression ]
      ...
      ELSE elseExpression
   END

Example:

   VALUES
      CASE
         WHEN 1 = 2 THEN 3
         WHEN 4 = 5 THEN 6
         ELSE 7
      END

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message