Thank you Ben, that worked.
----- Original Message -----
From: "Ben" <[EMAIL PROTECTED]>
To: "Julie May" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
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 [EMAIL PROTECTED] so that your
> message can get through to the mailing list cleanly
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
