Postgres Pro
Downloads
Home   >   mailing lists

Thread: Select Query Implementation:Details needed

Select Query Implementation:Details needed

From
RAJDEEP SARDAR
Date:
Dear All,

I am a Mtech Student,IIT Bombay,India.

I am having a database course project where I need to make some modification in postgresql.

currently,my objective is to find how a select query runs in postgresql.I have some knowledge related to parsing after going through some document uploaded

in the developer site.But I would like to know the steps after that.

Can anyone suggest

1.Which file/methods are handing the select query
2.Implementation of select

3.Any relevant document related to the topic


thanks,

Rajdeep



Re: Select Query Implementation:Details needed

From
Adrian Klaver
Date:
On 10/30/2012 04:07 AM, RAJDEEP SARDAR wrote:
> Dear All,
>
> I am a Mtech Student,IIT Bombay,India.
>
> I am having a database course project where I need to make some
> modification in postgresql.
>
> currently,my objective is to find how a select query runs in
> postgresql.I have some knowledge related to parsing after going through
> some document uploaded
>
> in the developer site.But I would like to know the steps after that.
>
> Can anyone suggest
>
> 1.Which file/methods are handing the select query
>
> 2.Implementation of select
>
> 3.Any relevant document related to the topic

http://www.postgresql.org/developer/backend/

Follow the links. Click on the chart to go to written description. Click
on description header to go to relevant code. The READMEs have quite a
bit of documentation.

>
>
> thanks,
>
> Rajdeep
>
>
>


--
Adrian Klaver
adrian.klaver@gmail.com

Re: Select Query Implementation:Details needed

From
Seref Arikan
Date:
Fantastic resource. Thanks for this!

On Tue, Oct 30, 2012 at 3:16 PM, Adrian Klaver <adrian.klaver@gmail.com> wrote:
On 10/30/2012 04:07 AM, RAJDEEP SARDAR wrote:
Dear All,

I am a Mtech Student,IIT Bombay,India.

I am having a database course project where I need to make some
modification in postgresql.

currently,my objective is to find how a select query runs in
postgresql.I have some knowledge related to parsing after going through
some document uploaded

in the developer site.But I would like to know the steps after that.

Can anyone suggest

1.Which file/methods are handing the select query

2.Implementation of select

3.Any relevant document related to the topic

http://www.postgresql.org/developer/backend/

Follow the links. Click on the chart to go to written description. Click on description header to go to relevant code. The READMEs have quite a bit of documentation.



thanks,

Rajdeep





--
Adrian Klaver
adrian.klaver@gmail.com


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Select Query Modification:Details needed

From
RAJDEEP SARDAR
Date:

Dear All,


I am having a database course project where I need to make some modification in postgresql.

For this I need to modify  a select query and add some condition to it.

I need to find out the formclause and whereclause of the select query after it is parsed.To do that,I have found a structure ListCell,which contains a void * ptr_val.It seems that probably this ptr_val is holding some structure within which the strings are stored.But I am not being able to access that as I dont know what kind of structure is pointed by ptr_val.

I am trying to modify analyze.c ,method:transformSelectStmt(ParseState *pstate, SelectStmt *stmt)

Can anyone share any idea how to access the formclause and whereclause of the select statement after the query being parsed?


thanks,

Rajdeep