Re: [HACKERS] Which file does the SELECT?

2010-11-10 Thread Vaibhav Kaushal
Yeah that is what seems to be the best way. The thing is that I am looking in the PostgreSQL code for the first time and I am not fully aware of the data structures or the methods / algos implemented in the project. This makes the work of finding out whats and whys much more difficult. So I asked

Re: [HACKERS] Which file does the SELECT?

2010-11-09 Thread Robert Haas
On Mon, Nov 8, 2010 at 9:55 PM, Vaibhav Kaushal vaibhavkaushal...@gmail.com wrote: I have started with the work and am using Eclipse and it helps quite a lot. I can find the declarations quite easily. Thanks to open Source. BTW, I am encountering too many (just too many) data types as I try to

Fwd: [HACKERS] Which file does the SELECT?

2010-11-08 Thread Vaibhav Kaushal
-- Forwarded message -- From: Vaibhav Kaushal vaibhavkaushal...@gmail.com Date: Tue, Nov 9, 2010 at 8:24 AM Subject: Re: [HACKERS] Which file does the SELECT? To: Dimitri Fontaine dimi...@2ndquadrant.fr I have started with the work and am using Eclipse and it helps quite a lot. I

Fwd: [HACKERS] Which file does the SELECT?

2010-11-08 Thread Vaibhav Kaushal
I have started with the work and am using Eclipse and it helps quite a lot. I can find the declarations quite easily. Thanks to open Source. BTW, I am encountering too many (just too many) data types as I try to understand the backend (specifically the executor). I do think that its normal

Re: [HACKERS] Which file does the SELECT?

2010-10-12 Thread Dimitri Fontaine
David Fetter da...@fetter.org writes: On Mon, Oct 11, 2010 at 04:14:04PM +0530, Vaibhav Kaushal wrote: Is there something like that in Kdevelop? I dont use CLI editors much. KDevelop is listed as one of the editors that support ctags. I've just developed some code for the backend and used

Re: [HACKERS] Which file does the SELECT?

2010-10-11 Thread Vaibhav Kaushal
Is there something like that in Kdevelop? I dont use CLI editors much. On Mon, Oct 11, 2010 at 7:55 AM, David Christensen da...@endpoint.comwrote: On Oct 10, 2010, at 12:21 PM, Vaibhav Kaushal wrote: Thanks to both hitoshi and tom for your replies. I think I need to look into the

Re: [HACKERS] Which file does the SELECT?

2010-10-11 Thread David Fetter
On Mon, Oct 11, 2010 at 04:14:04PM +0530, Vaibhav Kaushal wrote: Is there something like that in Kdevelop? I dont use CLI editors much. KDevelop is listed as one of the editors that support ctags. http://en.wikipedia.org/wiki/Ctags Cheers, David. -- David Fetter da...@fetter.org

[HACKERS] Which file does the SELECT?

2010-10-10 Thread Vaibhav Kaushal
I have gone through the source code a bit but I wanted to know that which file contains the code that performs the final SLECTION after the optimizer has created the final plan? I mean which part of the executor is responsible for the SELCT to be run? Can someone tell me the file which governs

Re: [HACKERS] Which file does the SELECT?

2010-10-10 Thread Peter Eisentraut
On sön, 2010-10-10 at 13:32 +0530, Vaibhav Kaushal wrote: I have gone through the source code a bit but I wanted to know that which file contains the code that performs the final SLECTION after the optimizer has created the final plan? I mean which part of the executor is responsible for the

Re: [HACKERS] Which file does the SELECT?

2010-10-10 Thread Vaibhav Kaushal
Thanks for the reply. So if I am not wrong, I will have to understand the whole querying process in detail? If it is so, then where do I start from? -Vaibhav On Sun, Oct 10, 2010 at 1:41 PM, Peter Eisentraut pete...@gmx.net wrote: On sön, 2010-10-10 at 13:32 +0530, Vaibhav Kaushal wrote: I

Re: [HACKERS] Which file does the SELECT?

2010-10-10 Thread Hitoshi Harada
2010/10/10 Vaibhav Kaushal vaibhavkaushal...@gmail.com: Thanks for the reply. So if I am not wrong, I will have to understand the whole querying process in detail? If it is so, then where do I start from? -Vaibhav On Sun, Oct 10, 2010 at 1:41 PM, Peter Eisentraut pete...@gmx.net wrote: On

Re: [HACKERS] Which file does the SELECT?

2010-10-10 Thread Tom Lane
Vaibhav Kaushal vaibhavkaushal...@gmail.com writes: So if I am not wrong, I will have to understand the whole querying process in detail? If it is so, then where do I start from? If you haven't seen it already, this is a good place to start:

Re: [HACKERS] Which file does the SELECT?

2010-10-10 Thread Vaibhav Kaushal
The PostgreSQL documentation (9.0.1) has the following section in section 44.5.1: The planner preferentially considers joins between any two relations for which there exist a corresponding join clause in the WHERE qualification (i.e., for which a restriction like where rel1.attr1=rel2.attr2

Re: [HACKERS] Which file does the SELECT?

2010-10-10 Thread Tom Lane
Vaibhav Kaushal vaibhavkaushal...@gmail.com writes: Can someone tell me what are 'Join Pairs with no Join clause' ? I am not able to figure that out! Consider select * from t1, t2, t3 where t1.a = t2.x and t1.b = t3.y; In theory this query could be done by first joining t2 and t3,

Re: [HACKERS] Which file does the SELECT?

2010-10-10 Thread Vaibhav Kaushal
Thanks to both hitoshi and tom for your replies. I think I need to look into the Postgres code itself (I am better at code than documentation). But since I have not been touch with C lately (these days I am programming on PHP) I think I have forgot a few rules of game (afterall PHP is so much

Re: [HACKERS] Which file does the SELECT?

2010-10-10 Thread Martijn van Oosterhout
On Sun, Oct 10, 2010 at 10:51:54PM +0530, Vaibhav Kaushal wrote: However, I find too many references to the Data structure datum what is it and where is it defined? Can someone tell me please? Also, what role does it play? Datum is the singular form of data. It refers to a single item of any

Re: [HACKERS] Which file does the SELECT?

2010-10-10 Thread David Christensen
On Oct 10, 2010, at 12:21 PM, Vaibhav Kaushal wrote: Thanks to both hitoshi and tom for your replies. I think I need to look into the Postgres code itself (I am better at code than documentation). But since I have not been touch with C lately (these days I am programming on PHP) I think