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

From: Darren Duncan <darren(at)darrenduncan(dot)net>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Proposal: plpgsql - "for in array" statement
Date: 2010-09-29 01:31:11
Message-ID: 4CA296DF.5070105@darrenduncan.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Itagaki Takahiro 2010-09-29 01:33:21 Re: [RRR] [HACKERS] Commitfest: The Good, The Bad, and the Ugly
Previous Message Robert Haas 2010-09-29 01:27:43 Re: Path question