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

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

pgsql-general by date

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

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