Message-Id: <08F9706F-C603-46A2-8D42-5799D700DCE7@ruprecht.org>
From: Chris Ruprecht <chris@ruprecht.org>
To: pgsql-sql@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1; format=flowed; delsp=yes
Content-Transfer-Encoding: quoted-printable
Mime-Version: 1.0 (Apple Message framework v930.3)
Subject: Variable number or arguments to a function possible?
Date: Fri, 24 Apr 2009 22:04:54 -0400

Hello everybody,

Is it possible to create a function that can take a variable number of =20=

arguments?
I would like to write a function that creates a new record in the =20
database. Based on what I send it, it should create a record in the =20
appropriate table.

Simple pseudo-code example:

... function create_record( varchar [,...] ) returns bigint as

if $1 =3D 'state' then insert into state ( $2, $3 ) // $2 being state =20=

name, and $3 state code
if $1 =3D 'phone' then insert into phone ( $4::bigint, $2, $3 ) // $2 =3D =
=20
phone number, $3 =3D phone type, $4 =3D id of person that ownes the =
phone

and so on.

How would I declare that function?

Thanks.


best regards,
chris
--=20
chris ruprecht
database grunt and bit pusher extraordina=EDre