Re: arrays as parameters to pl/pgsql functions

Thank you Ben, that worked.

----- Original Message -----
From: "Ben" <bench@silentmedia.com>
To: "Julie May" <julie@ccorb.com>
Cc: <pgsql-general@postgresql.org>
Sent: Monday, November 17, 2003 3:17 PM
Subject: Re: [GENERAL] arrays as parameters to pl/pgsql functions


> On Mon, 17 Nov 2003, Julie May wrote:
>
> > 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:
>
>
> CREATE or REPLACE FUNCTION foo(integer[]) RETURNS int AS
> 'DECLARE
> a alias for $1;
> index   integer := 1;
> total   integer := 0;
> BEGIN
> WHILE a[index] > 0
> LOOP
> total := total + a[index];
> index := index + 1;
> END LOOP;
>
> RETURN total;
>         END;
> ' LANGUAGE 'plpgsql';
>
>
>
> test=> select foo('{1,2}');
>  foo
> -----
>    3
> (1 row)
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly