Re: [GENERAL] Stored function - send array as parameter to stored function

2008-11-13 Thread Tom Lane
brian <[EMAIL PROTECTED]> 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 mailin

Re: [GENERAL] Stored function - send array as parameter to stored function

2008-11-12 Thread brian
Yes, this one got me, also. Strangely, you need to do: select iterate('{1,2}'); Also, you have a typo in your function: arry_upper(a,1) b hendra kusuma wrote: Hi, I'm new here I've been doing a little self-learning about postgresql and find it very interesting I've been trying to create a

[GENERAL] Stored function - send array as parameter to stored function

2008-11-12 Thread hendra kusuma
Hi, I'm new here I've been doing a little self-learning about postgresql and find it very interesting I've been trying to create a stored procedure that receive array as parameter and find a good and working example on the web the code looks like this create or replace function iterate(a int[])