Postgres Pro
Downloads
Home   >   mailing lists

Re: why does documentation use "END CASE" when that doesn't work - Mailing list pgsql-general

From Jov
Subject Re: why does documentation use "END CASE" when that doesn't work
Date
Msg-id CADyrUxMZB2OGm_XwXDQ_8K9GU_O0cKnSSzquq-zZniS2uPV9oQ@mail.gmail.com
Whole thread Raw
In response to why does documentation use "END CASE" when that doesn't work  (Susan Cassidy <susan.cassidy@decisionsciencescorp.com>)
List pgsql-general
Tree view

plpgsql case use end case，while sql case use end，they are different language

jov

在 2014-2-26 上午8:32，"Susan Cassidy" <susan.cassidy@decisionsciencescorp.com>写道：
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


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: why does documentation use "END CASE" when that doesn't work
Next
From: Sergey Konoplev
Date:
Subject: Re: Adding a non-null column without noticeable downtime