DO
$do$
DECLARE
a integer[] := array[1,2,3];
i integer; -- int, not bigint
BEGIN
FOR i IN 1 .. array_upper(a, 1)
LOOP
RAISE NOTICE '%', a[i]; -- single quotes
END LOOP;
END
$do$;
或者FOREACH在 Postgresql 9.1 或更高版本中更简单:
FOREACH i IN ARRAY a
LOOP
RAISE NOTICE '%', i;
END LOOP;