Re: Stored function - send array as parameter to stored function - Mailing list pgsql-general

From Tom Lane
Subject Re: Stored function - send array as parameter to stored function
Date
Msg-id 3341.1226581493@sss.pgh.pa.us
Whole thread Raw
In response to Re: Stored function - send array as parameter to stored function  (brian <brian@zijn-digital.com>)
List pgsql-general
brian <brian@zijn-digital.com> writes:
> Yes, this one got me, also. Strangely, you need to do:
> select iterate('{1,2}');

In reasonably modern versions of PG you could use an array constructor:

select iterate(array[1,2,3]);

            regards, tom lane

pgsql-general by date:

Previous
From: "Markus Wollny"
Date:
Subject: Re: Suboptimal execution plan for simple query
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] ERROR: incompatible library