calling stored procedure with array paramenter (for psql)

From: Assad Jarrahian <jarraa(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: calling stored procedure with array paramenter (for psql)
Date: 2006-01-10 00:33:53
Message-ID: 4bd3e1480601091633q79a2a7d8m6b9111fa29bef5ee@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a pg_psql stored procedure

getlms(_int4)

from psql

SELECT * fROM get_lms(ARRAY[12,23,34]);

that does not work. How do I pass an array to a function in psql?
Please help. Thanks.
-assad

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2006-01-10 00:52:52 Re: calling stored procedure with array paramenter (for psql)
Previous Message Bruce Momjian 2006-01-09 23:46:03 Re: [ANNOUNCE] CRITICAL RELEASE: Minor Releases to Fix DoS