Hello,
Does PL/PGSQL support arrays? Or is their a mechanism to select a set of
records from a table and iterate over all of them.
For example:
DECLARE recs AS RECORDS; //??
BEGIN
SELECT INTO recs * FROM mytable WHERE myfield = 'myvalue';
for i in 1 .. NumRecs loop
...
end loop;
Is there a way to do something like this??
Wade Oberpriller