Re: proposal for 8.4: PL/pgSQL - statement CASE

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: proposal for 8.4: PL/pgSQL - statement CASE
Дата
Msg-id 162867790801170819s588c25cfl2653fc8036bf8111@mail.gmail.com
обсуждение исходный текст
Ответ на Re: proposal for 8.4: PL/pgSQL - statement CASE  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: proposal for 8.4: PL/pgSQL - statement CASE  ("Brendan Jurd" <direvus@gmail.com>)
Список pgsql-hackers
Hello

>
> Isn't there a danger of syntactical conflict with the SQL SELECT ... CASE
> statement?
>

no, isn't. SELECT CASE can be only in expression .. inside SQL
statement, but PL/SQL CASE is PL statement. These are two different
worlds. SELECT CASE is invisible for pl parser, because pl parser
solves statements, not expressions.

> I'd love to have CASE in PL/pgSQL, but I always thought that stood in the way.
>

it's safe. SQL/PSM use it too.

Pavel


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: proposal for 8.4: PL/pgSQL - statement CASE
Следующее
От: "Pavel Stehule"
Дата:
Сообщение: Re: proposal for 8.4: PL/pgSQL - statement CASE