| From: | Jov <zhao6014(at)gmail(dot)com> |
|---|---|
| To: | Susan Cassidy <susan(dot)cassidy(at)decisionsciencescorp(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: why does documentation use "END CASE" when that doesn't work |
| Date: | 2014-02-26 01:09:52 |
| Message-ID: | CADyrUxMZB2OGm_XwXDQ_8K9GU_O0cKnSSzquq-zZniS2uPV9oQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
plpgsql case use end case，while sql case use end，they are different language
jov
在 2014-2-26 上午8:32，"Susan Cassidy" <susan(dot)cassidy(at)decisionsciencescorp(dot)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
>
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sergey Konoplev | 2014-02-26 01:15:13 | Re: Adding a non-null column without noticeable downtime |
| Previous Message | Tom Lane | 2014-02-26 00:43:47 | Re: why does documentation use "END CASE" when that doesn't work |