Re: plpgsql and arrays - Mailing list pgsql-general

Artis Caune wrote:
> Thanks a lot!
> Normal upper/lower loop works fine:
>
>
> CREATE OR REPLACE FUNCTION add_user( VARCHAR(128)[] ) RETURNS SMALLINT

I'd rename the function "add_users()"

> AS $$
> DECLARE
>   v_uid SMALLINT;
>   v_low SMALLINT;
>   v_upp SMALLINT;
>   empty BOOLEAN := TRUE;
> BEGIN
>   SELECT INTO v_low array_lower($1,1);
>   SELECT INTO v_upp array_upper($1,1);

You can also write this:
   v_low := array_lower($1,1);

--
   Richard Huxton
   Archonet Ltd