Thread: Function problem again...

Function problem again...

From
Mole
Date:
Hello,
I hope this is a quick question, I want to create a function that will take a
number of varchars as input .
If it was a single varchar as input i know it would be

CREATE FUNCTION "user_id_funct_p3" (varchar) RETURNS varchar AS '

and if it is multiple I think it would be

CREATE FUNCTION "user_id_funct_p3" (varchar varchar varchar) RETURNS varchar
AS '

however i the number of inputs are not going to be constant do I have to
generate the function every time.. with the right number of inputs or is
there a way to tell a function that the input will be setof varchar

I hope I am making sense

Thanks in advance

Mole


Re: Function problem again...

From
"Henshall, Stuart - Design & Print"
Date:

Mole wrote:
> Hello,
> I hope this is a quick question, I want to create a function that
> will take a number of varchars as input .
> If it was a single varchar as input i know it would be
>
> CREATE FUNCTION "user_id_funct_p3" (varchar) RETURNS varchar AS '
>
> and if it is multiple I think it would be
>
> CREATE FUNCTION "user_id_funct_p3" (varchar varchar varchar) RETURNS
> varchar AS '
>
> however i the number of inputs are not going to be constant do I have
> to generate the function every time.. with the right number of inputs
> or is there a way to tell a function that the input will be setof
> varchar
>
> I hope I am making sense
>
> Thanks in advance
>
> Mole
>
There is no equivalent of varargs for function decalarations.
Also to specify multiple arguments you use commas:
CREATE FUNTION tst_func(text,text,text) .......
hth,
- Stuart