Re: [GENERAL] How to use the SQL parser subsystem

2007-01-04 Thread Tom Lane
Martijn van Oosterhout writes: > On Thu, Jan 04, 2007 at 08:01:17PM +0530, Ravindra Jaju wrote: >> 2] If yes, I found that none of the shared library files expose this >> function - I could not link a simple C program with this function >> successfully. (I tried all the .so files related to postgr

Re: [GENERAL] How to use the SQL parser subsystem

2007-01-04 Thread Ravindra Jaju
On 1/4/07, Tatsuo Ishii <[EMAIL PROTECTED]> wrote: > 3] If not, what would be a better mechanism to re-use all the work already > done in postgres for SQL analysis? One idea would be writing a PostgreSQL function which calls raw_parser() and returns the parse tree as a texual representaion. An

Re: [GENERAL] How to use the SQL parser subsystem

2007-01-04 Thread Ravindra Jaju
Hi. That was informative. Thanks. The reason I started pursuing this path was that this file (parser/parser.h) happens to be distributed as part of some 'devel' package, making me think that it might be possible to re-use the SQL parsing functionality that exists within postgres. Even if it is

Re: [GENERAL] How to use the SQL parser subsystem

2007-01-04 Thread Tatsuo Ishii
> Hi. > > Is it possible to use the SQL parser embedded inside the postgres code via > some public API? > I wish to get a parsed SQL query in any format which lends itself to easy > analysis (structural, for example) so as to be able to find similarities > between queries. > > I tried peeking aro

Re: [GENERAL] How to use the SQL parser subsystem

2007-01-04 Thread Martijn van Oosterhout
On Thu, Jan 04, 2007 at 08:01:17PM +0530, Ravindra Jaju wrote: > I tried peeking around a bit, and tried pulling out src/backend/parser - but > that depends on other parts of the code, making it a bit non-trivial. Plus, > any changes in the base code upstream would not be available to this > pulled