Hi
now we have lot of nice json related functions and I think so can be nice
if plpgsql's statement FOREACH can directly support json type. It can save
some CPY cycles by reducing some transformations.
My idea is following -
new syntax
FOREACH targetvar IN JSON ARRAY json array expr
LOOP
...
and
FOREACH targetvar, keyvar IN JSON OBJECT json record expr
LOOP
...
What do you think about this proposal? Comments, notes?
Regards
Pavel