Re: [HACKERS] merging some features from plpgsql2 project

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: [HACKERS] merging some features from plpgsql2 project
Дата
Msg-id CAFj8pRA3Uqg3iRiQEerKXft6AFv-M7XjNZnFeG-eSieRgdto8w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] merging some features from plpgsql2 project  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Список pgsql-hackers
Hi



 Real support for using variables as identifiers / nothing restricted to only accepting a Const.


This point is problematic not only from performance perspective.

if you don't use some special syntax and you allow variables as identifier, then you will got a ambiguous situation quickly - although variables can have special symbol prefix 

SELECT * FROM tab WHERE $var1 = $var3

What is $var1, what is $var2? identifier or value? 

Regards

Pavel 

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Dilip Kumar
Дата:
Сообщение: Re: [HACKERS] Parallel bitmap heap scan
Следующее
От: Anastasia Lubennikova
Дата:
Сообщение: Re: [HACKERS] WIP: Covering + unique indexes.