Skip site navigation (1) Skip section navigation (2)

proposal for 8.4: PL/pgSQL - statement CASE

From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
To: "Pgsql Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: proposal for 8.4: PL/pgSQL - statement CASE
Date: 2008-01-17 15:01:18
Message-ID: 162867790801170701q69d5a3b6h58a0a9a8c624dd8f@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Hello

I found so PL/SQL support CASE statement
http://download-east.oracle.com/docs/cd/B10500_01/appdev.920/a96624/04_struc.htm#484

I propose add this statement to PL/pgSQL too.

Reasons:

a) it's useful construct,
b) this statement is defined in SQL/PSM - better conformance with ANSI

Implementation:
This statement is implemented in PL/pgPSM, so implementation will be
backported to PL/pgSQL.

Any ideas?

Regards
Pavel Stehule

Responses

pgsql-hackers by date

Next:From: Josh BerkusDate: 2008-01-17 15:49:17
Subject: Re: proposal for 8.4: PL/pgSQL - statement CASE
Previous:From: Stephen FrostDate: 2008-01-17 14:37:29
Subject: Re: [ADMIN] postgresql in FreeBSD jails: proposal

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group