why does documentation use "END CASE" when that doesn't work

From: Susan Cassidy <susan(dot)cassidy(at)decisionsciencescorp(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: why does documentation use "END CASE" when that doesn't work
Date: 2014-02-26 00:29:25
Message-ID: CAE3Q8ong3-3kSYXSNBUmCd2by_U0A=6DesbMiTnDLonJ9-OrEQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

The documentation says:

CASE search-expression
WHEN expression [, expression [ ... ]] THEN
statements
[ WHEN expression [, expression [ ... ]] THEN
statements
... ]
[ ELSE
statements ]
END CASE;

And it repeats the "END CASE" phrase in other examples.

However, that doesn't work. You have to just use "END".

Shouldn't the documentation be fixed?

Susan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2014-02-26 00:43:47 Re: why does documentation use "END CASE" when that doesn't work
Previous Message Thom Brown 2014-02-25 23:37:04 Re: How can I use the crosstab() function?