Re: [HACKERS] merging some features from plpgsql2 project - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: [HACKERS] merging some features from plpgsql2 project
Date
Msg-id CAFj8pRA3Uqg3iRiQEerKXft6AFv-M7XjNZnFeG-eSieRgdto8w@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] merging some features from plpgsql2 project  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List 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 by date:

Previous
From: Dilip Kumar
Date:
Subject: Re: [HACKERS] Parallel bitmap heap scan
Next
From: Anastasia Lubennikova
Date:
Subject: Re: [HACKERS] WIP: Covering + unique indexes.