Home » PlItems » Über alle Array-Elemente interieren (PL/pgSQL)

Über alle Array-Elemente interieren

ID301
Link Referencehttps://stackoverflow.com/questions/9783422/loop-over-array-dimension-in-plpgsql
Link Creditshttps://stackoverflow.com/a/9784986
Link Technical DocumentationNot set
PlCodelangPL/pgSQL
PlGroupArray
PlItemTitleÜber alle Array-Elemente interieren
CodeDO
$do$
DECLARE
m text[];
arr text[] := '{{key1,val1},{key2,val2}}'; -- array literal
BEGIN
FOREACH m SLICE 1 IN ARRAY arr
LOOP
RAISE NOTICE 'another_func(%,%)', m[1], m[2];
END LOOP;
END
$do$;

-- ---------------------------------------------------------

DO
$do$
DECLARE
i text;
arr text[] := '{key1,key2}'; -- array literal
BEGIN
FOREACH i IN ARRAY arr
LOOP
RAISE NOTICE 'another_func(%)', i;
END LOOP;
END
$do$;
Result Example