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

From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
To: "Josh Berkus" <josh(at)agliodbs(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: proposal for 8.4: PL/pgSQL - statement CASE
Date: 2008-01-17 16:19:12
Message-ID: 162867790801170819s588c25cfl2653fc8036bf8111@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2008-01-17 16:21:55 Re: proposal for 8.4: PL/pgSQL - statement CASE
Previous Message Simon Riggs 2008-01-17 16:18:56 Re: proposal for 8.4: PL/pgSQL - statement CASE