From: | Chris Ruprecht <chris(at)ruprecht(dot)org> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Variable number or arguments to a function possible? |
Date: | 2009-04-25 02:04:54 |
Message-ID: | 08F9706F-C603-46A2-8D42-5799D700DCE7@ruprecht.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Milen A. Radev | 2009-04-25 03:08:25 | Re: Variable number or arguments to a function possible? |
Previous Message | Tom Lane | 2009-04-24 14:32:08 | Re: varchar value comparisons not working? |