Re: Array as parameter for plpgsql function

From: David Pratt <fairwinds(at)eastlink(dot)ca>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Array as parameter for plpgsql function
Date: 2005-07-13 15:09:13
Message-ID: 12CC07A3-F3B0-11D9-97E3-000A27B3B070@eastlink.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 <fairwinds(at)eastlink(dot)ca> 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 create_record_test(ARRAY[ARRAY['A','test one'],ARRAY['B','test
>> two']]) AS output;
>
> Works fine for me, once I add the semicolon you forgot:
>
> return array_upper(test_array,1);
>
> regards, tom lane
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that
> your
> message can get through to the mailing list cleanly
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-07-13 15:28:28 Re: Strange memory behaviour with PGreset() ...
Previous Message marcelo Cortez 2005-07-13 15:07:07 fts error