Skip site navigation (1) Skip section navigation (2)

Variadic functions and name

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Victor JasonDate: 2009-09-02 06:41:14
Subject: Backup aggregate function
Previous:From: Michael WoodDate: 2009-09-01 15:11:19
Subject: Re: Problem starting pgsql server on Mac OS X. Pg_hba.conf reading permission.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group