Re: FW: [HACKERS] decode() function for PostgreSQL

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Archana Bharatee <archana(at)ecomscience(dot)com>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: FW: [HACKERS] decode() function for PostgreSQL
Date: 2002-02-28 03:48:56
Message-ID: 200202280348.g1S3mud20661@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches


That is fine. We can merge it into the system catalogs once it is
reviewed. Thanks.

---------------------------------------------------------------------------

Archana Bharatee wrote:
> Dear Bruce,
>
> I am not familiar with the process of applying patches. I am attaching the
> source-code for the decode function we have developed for PostgreSQL. Can
> you please do the needful, or redirect me to the appropriate person.
>
> Thanks a lot,
>
> warm regards,
> Archana Bharatee
>
> -----Original Message-----
> From: Bruce Momjian [mailto:pgman(at)candle(dot)pha(dot)pa(dot)us]
> Sent: Monday, February 25, 2002 10:33 PM
> To: Archana Bharatee
> Cc: pgsql-hackers(at)postgresql(dot)org
> Subject: Re: [HACKERS] decode()
>
>
> Archana Bharatee wrote:
> > We have developed a 'C' function to provide Oracle decode() functionality.
> > we have developed a C function DECODE which accepts an SQL Query and
> > replaces occurence of decode with case-when-then-else-end and returns the
> > query. There is no limitation of fixed number of parameters. This needs
> to
> > be added to PostgreSQL library. How do we do this?
>
> Send the patch to the patches list. A context diff against against 7.2
> or CVS is just fine.
>
> --
> Bruce Momjian | http://candle.pha.pa.us
> pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill, Pennsylvania 19026

[ Attachment, skipping... ]

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Fernando Nasser 2002-03-01 14:02:27 Allows for commands to be processed iteractively
Previous Message Tom Lane 2002-02-27 19:11:25 Re: Fix issuing of multiple command completions per command