From: | Adam Wałach <adam(dot)walach(at)gmail(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Variadic functions and name |
Date: | 2009-09-01 15:12:14 |
Message-ID: | 1f5923d40909010812j190eeebam91dda26f123283ab@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi
I am plaing with functions with variable number of arguments. I found an
example of such a function at
http://www.depesz.com/index.php/2008/07/31/waiting-for-84-variadic-functions/
.
Up to this point everything is clear, all the parameters are of the same
type and function works.
But I wan't to simulate named function arguments (as in oracle funct_name
(arg1 => test) - syntax is not so important). I also found another examle (
http://archives.postgresql.org/pgsql-patches/2008-01/msg00103.php)
Syntax in this example is as follows:
select json_object('value1' as name, 'value2' as surname);
Function declaration :
json_object(anyparams)
I am trying to write similar function in plpgsql but all I get is 'type
anyparams does not exist'.
Is it possible?
--
Regards, Adam Wałach
From | Date | Subject | |
---|---|---|---|
Next Message | Victor Jason | 2009-09-02 06:41:14 | Backup aggregate function |
Previous Message | Michael Wood | 2009-09-01 15:11:19 | Re: Problem starting pgsql server on Mac OS X. Pg_hba.conf reading permission. |