Re: Proposal: plpgsql - "for in array" statement - Mailing list pgsql-hackers

From Darren Duncan
Subject Re: Proposal: plpgsql - "for in array" statement
Date
Msg-id 4CA296DF.5070105@darrenduncan.net
Whole thread Raw
In response to Re: Proposal: plpgsql - "for in array" statement  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Proposal: plpgsql - "for in array" statement  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Path question
Next
From: Itagaki Takahiro
Date:
Subject: Re: [RRR] Commitfest: The Good, The Bad, and the Ugly