Function problem again...

From: Mole <mole(at)zebra(dot)co(dot)uk>
To: pgsql-novice(at)postgresql(dot)org
Subject: Function problem again...
Date: 2002-11-04 11:20:20
Message-ID: E188fFs-000469-00@zebrahosts.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Browse pgsql-novice by date

  From Date Subject
Next Message Kassel Ben CRBE 2002-11-04 11:41:58 AutoIncrement not working on this table only
Previous Message debianabbestia@inwind.it 2002-11-04 11:11:37 Re: information