From: Chris Ruprecht <chris@ruprecht.org>
To: pgsql-sql@postgresql.org
Subject: Variable number or arguments to a function possible?
Date: Fri, 24 Apr 2009 22:04:54 -0400
Message-ID: <08F9706F-C603-46A2-8D42-5799D700DCE7@ruprecht.org> (raw)
Hello everybody,
Is it possible to create a function that can take a variable number of
arguments?
I would like to write a function that creates a new record in the
database. Based on what I send it, it should create a record in the
appropriate table.
Simple pseudo-code example:
... function create_record( varchar [,...] ) returns bigint as
if $1 = 'state' then insert into state ( $2, $3 ) // $2 being state
name, and $3 state code
if $1 = 'phone' then insert into phone ( $4::bigint, $2, $3 ) // $2 =
phone number, $3 = phone type, $4 = id of person that ownes the phone
and so on.
How would I declare that function?
Thanks.
best regards,
chris
--
chris ruprecht
database grunt and bit pusher extraordinaíre
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: chris@ruprecht.org
Subject: Re: Variable number or arguments to a function possible?
In-Reply-To: <08F9706F-C603-46A2-8D42-5799D700DCE7@ruprecht.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox