Re: How to create function with unspecified number of input parameters

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: MindTerm <mindterm(at)yahoo(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: How to create function with unspecified number of input parameters
Date: 2001-11-25 05:29:05
Message-ID: 200111250529.fAP5T6G00259@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> MindTerm <mindterm(at)yahoo(dot)com> writes:
> > I am writing to ask how to create function ( CREATE
> > FUNCTION ) with unspecified number of input parameters
>
> CREATE FUNCTION doesn't presently support that.
>
> If the underlying function is written in C, you can fake it by
> issuing multiple CREATE FUNCTION commands with different numbers
> of declared parameters, all of which point to the same C function.
> Then the C code would have to look at fcinfo->nargs to see how it
> had been called.

Is this a TODO item?

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-11-25 05:38:01 Re: How to create function with unspecified number of input parameters ?
Previous Message Tom Lane 2001-11-25 04:49:38 Re: How to create function with unspecified number of input parameters ?