Обсуждение: decode()

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

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,
Pennsylvania19026