argh!!! It was telling me I had an error in select statement. Thanks
Tom!
Regards
David
On Wednesday, July 13, 2005, at 11:08 AM, Tom Lane wrote:
David Pratt <[EMAIL PROTECTED]> writes:
CREATE FUNCTION create_record_test(text[][]) RETURNS int4 AS '
DECLARE
test_array ALIAS F
David Pratt <[EMAIL PROTECTED]> writes:
> CREATE FUNCTION create_record_test(text[][]) RETURNS int4 AS '
> DECLARE
> test_array ALIAS FOR $1; -- alias for input array
> BEGIN
> return array_upper(test_array,1)
> END;
> ' LANGUAGE 'plpgsql';
> SELECT
How does one pass an array as a parameter to a plpgsql function? I
have tried this the following. I can't seem to get a select statement
to work without syntax problems and no examples in Postgres book to
help with this :( This is just a test so please ignore the fact it is
a simple function.
