On Mon, Jan 09, 2006 at 08:17:17PM -0700, Assad Jarrahian wrote:
> CREATE OR REPLACE FUNCTION getlms(_int4)
> RETURNS SETOF tp_locationmessage_object AS
> $BODY$
> DECLARE
> ...
>
>
> SELECT * FROM getLMs();
>
> ... so lets say I want to send an array contain 1,23,34 ...
>
> how do I do
CREATE OR REPLACE FUNCTION getlms(_int4)
RETURNS SETOF tp_locationmessage_object AS
$BODY$
DECLARE
...
SELECT * FROM getLMs();
... so lets say I want to send an array contain 1,23,34 ...
how do I do that .. whats the syntax?
On 1/9/06, Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Mon,
On Mon, Jan 09, 2006 at 05:33:53PM -0700, Assad Jarrahian wrote:
> 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?
Could you explain what "does not work" means?
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
---(end of broadcast)---
TIP 1: if posting/reading thr
