Postgres Pro
Downloads
Home   >   mailing lists

arrays as parameters to pl/pgsql functions - Mailing list pgsql-general

From Julie May
Subject arrays as parameters to pl/pgsql functions
Date
Msg-id 03e701c3ad52$b93b9880$687ba8c0@impsu.net
Whole thread Raw
In response to Visio Like Tool....  ("Thomas LeBlanc" <thomasatiem@hotmail.com>)
Responses Re: arrays as parameters to pl/pgsql functions  (Ben <bench@silentmedia.com>)
List pgsql-general
Tree view 
Is it possible to use an array as a parameter to a pl/pgsql function. I am
running version 7.3 and don't have the time right now to upgrade.If it is
possible, how do you iterate through the array? For example:

phpVariable[0]=1;
phpVariable[1]=2;
phpVariable[2]=3;

some_pl/pgsql_function(phpVariable?)
how do you access phpVariable[2] within the function?

Thanks.

Julie

pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: embedded postgresql + C++ IDE
Next
From: "Marc G. Fournier"
Date:
Subject: PostgreSQL v7.4 Released