Re: Stored function - send array as parameter to stored function

[Tom Lane <tgl@xxxxxxxxxxxxx>]

brian <brian@xxxxxxxxxxxxxxxx> 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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general