Postgres Pro
Downloads
Home   >   mailing lists

Thread: Re: Case clause doesn't report syntactic error

Re: Case clause doesn't report syntactic error

From
"David G. Johnston"
Date:
On Saturday, September 14, 2024, Leo Volin <lvolin@intelligentaudit.com> wrote:

It doesn't match the documented format: 
CASE WHEN condition THEN result
     [WHEN ...]
     [ELSE result]
END
As long as the type of entry between CASE and first WHEN matches type of WHEN conditions no syntax error is being generated!

Read the entire section documenting case.


There are two forms documented - the general and then the “simple” variant.  You example demonstrates the later.

David J.