Thread: [GENERAL] Adding a new Clause in the Source Code

[GENERAL] Adding a new Clause in the Source Code

From
"Stefan Wagner"
Date:
Recently I started to take a look at Postgresql on the Source Level. I wanted to extend the Parser by a simple Clause which isn't as easy as I expected.
Hence I'm here asking for help. This might seem trivial for a Person which is able to answer this Question but please take a moment of your time and help a
fellow coder out. 
 
My Objective is to add a new Clause after the WHERE Clause in a SELECT Statement which modifys the order of my result. I allready invested some time to get familar
with the Bison part in source\src\backend\parser so adding new Keywords seems possible. The question now is in which Files do I need to add what to make it work.
Yes this question seems a bit broad but Information I found was confusing or outdated.
 
I would really appreciate if someone could hack me a quick example of a new clause lets call it ADDITIONAL with Keywords HIGH, LOW to order columns. I just want the construct. What
the Keywords accomplish and the Algorithm is something I'm gonna try to figure out on my own. I just need to know in which File and which Line I need to enter my Code.
 
I appreciate any help I can get and if needed I'll add some additional Information.

Re: [GENERAL] Adding a new Clause in the Source Code

From
Peter Eisentraut
Date:
On 8/14/17 04:14, Stefan Wagner wrote:
> I would really appreciate if someone could hack me a quick example of a
> new clause lets call it ADDITIONAL with Keywords HIGH, LOW to order
> columns. I just want the construct. What
> the Keywords accomplish and the Algorithm is something I'm gonna try to
> figure out on my own. I just need to know in which File and which Line I
> need to enter my Code.

For projects like this, figuring out all the places where to change
things is often half the work.

If I were to approach this, I would see how ORDER BY is implemented and
track all those places down and then see whether I need to make
analogous changes there.

--
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services