Thanks for the answer but the resource connection is optional and in this script there is no ambiguity since there is only one connection. I added the connection to pg_query any way and the script still fails. I went through archives and saw that others had the same problem with using a PHP arrays as a parameter to a Postgresql function. I have not found a solution though; any thought?
----- Original Message ---- From: Talha Khan <talha.amjad@gmail.com> To: Jean-Christophe Roux <jcxxr@yahoo.com> Cc: pgsql-php@postgresql.org Sent: Wednesday, November 8, 2006 3:25:29 PM Subject: Re: [PHP] function with array parameter
Hello, I have a function that I would like to call from a php script:
CREATE OR REPLACE FUNCTION a_dummy(arr_in text[]) RETURNS text AS $BODY$ declare begin return arr_in[1]; end; $BODY$ LANGUAGE 'plpgsql' VOLATILE;
and the php code would be something like that $arr; $arr[0] = "one"; $arr[1] = 'two'; $query = "select func_a_dummy($arr)"; $result = pg_query($query); echo pg_fetch_result($result, 0, 0);
but the syntax is wrong. Any idea what I should do to make it work Thank you