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

Поиск
Список
Период
Сортировка
От Darren Duncan
Тема Re: Proposal: plpgsql - "for in array" statement
Дата
Msg-id 4CA296DF.5070105@darrenduncan.net
обсуждение исходный текст
Ответ на Re: Proposal: plpgsql - "for in array" statement  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: Proposal: plpgsql - "for in array" statement  (Andrew Dunstan <andrew@dunslane.net>)
Список 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 по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Path question
Следующее
От: Itagaki Takahiro
Дата:
Сообщение: Re: [RRR] Commitfest: The Good, The Bad, and the Ugly