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?


regards,
Archana


Mon, 25 Feb 2002 18:26:57 +0530
"Archana Bharatee" <archana@ecomscience.com>
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@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Mon, 25 Feb 2002 12:02:55 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: decode()