Re: Proposal: plpgsql - "for in array" statement

Alvaro Herrera wrote:
> What about
>
> FOR EACH var IN array_expr LOOP ...
>
> I think this requires reserving EACH, which could cause a regression for
> working code. Maybe there's a way to make it work?

Code that quotes all of its identifiers, such as with:

FOR EACH "var" IN "array_expr" LOOP ...

... would also gain a significant amount of future-proofing since then the
language can add keywords at will, without there being conflicts with
user-defined identifiers.

Similarly, quoting identifiers also carries present-day advantages as then one
can name identifiers whatever is most suitably descriptive for them without
worrying whether the language has a pre-defined meaning for the used words.

The quoting also has the nice bonus of making them case-sensitive.

-- Darren Duncan