Postgres Pro
Downloads
Home   >   mailing lists

proposal for 8.4: PL/pgSQL - statement CASE - Mailing list pgsql-hackers

From Pavel Stehule
Subject proposal for 8.4: PL/pgSQL - statement CASE
Date
Msg-id 162867790801170701q69d5a3b6h58a0a9a8c624dd8f@mail.gmail.com
Whole thread Raw
Responses Re: proposal for 8.4: PL/pgSQL - statement CASE  (Josh Berkus <josh@agliodbs.com>)
Re: proposal for 8.4: PL/pgSQL - statement CASE  (Simon Riggs <simon@2ndquadrant.com>)
Re: proposal for 8.4: PL/pgSQL - statement CASE  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: [ADMIN] postgresql in FreeBSD jails: proposal
Next
From: Josh Berkus
Date:
Subject: Re: proposal for 8.4: PL/pgSQL - statement CASE