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