How to modify parser in PostgreSQL to handle new keyword and parse it

From: Rajmohan C <csrajmohan(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How to modify parser in PostgreSQL to handle new keyword and parse it
Date: 2014-08-14 16:39:09
Message-ID: CAHaqV0gZ_C9iqsHaDfQQxc2HxwaeYWjCesFVHK1-AMJA9xkMKg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am working on implementing Selectivity hints feature in PostgreSQL 9.3.4.
I am working on this only for using it in my academic research. I have
decided to give selectivity information per relation as part of query like
shown below.

select * from lineitem, orders where l_extendedprice <=2400 and l_orderkey
= o_orderkey selectivity(lineitem, 0.3) selectivity(orders, 0.7);

I tried separating the selectivity hint portion of the query before
Postgres parses query. But it becomes very clumsy. I am thinking Postgres
parser modification to handle this case could be complex that is why I did
not get into Postgres grammar and parser. How should I take this
selectivity hints separate from a normal query and populate in my data
structures?

Browse pgsql-general by date

  From Date Subject
Next Message Bill Mitchell 2014-08-14 17:53:15 Re: Best practices for cloning DB servers
Previous Message Tom Lane 2014-08-14 16:23:53 Re: is there a way log last query in pg_stat_activity