Thread: Info on SQL Parsing required

Info on SQL Parsing required

From
CHAITANYANC
Date:
Hi
Can anybody tell me where I can find the ways of parsing an sql statement
and making a query plan ?
Thanks in advance
Chaitu


Re: [SQL] Info on SQL Parsing required

From
neko@kredit.sth.szif.hu
Date:
On Wed, 24 Nov 1999, CHAITANYANC wrote:
> Can anybody tell me where I can find the ways of parsing an sql statement
> and making a query plan ?
programmers.ps maybe. You can do this only on server side (if i right).
Read the parts about SPI (server programing interface). There are
functions for pre-parse query -> save plan, and for run the saved plan.

--nek;(



Re: [SQL] Info on SQL Parsing required

From
Peter Eisentraut
Date:
The relevant code is in src/backend/parser. If you need to reproduce this
for some unrelated purpose, you're in for a lot of work, as SQL wasn't
necessarily designed for easy parsability.

On 1999-11-24, CHAITANYANC mentioned:

> Hi
> Can anybody tell me where I can find the ways of parsing an sql statement
> and making a query plan ?
> Thanks in advance
> Chaitu
> 
> ************
> 
> 

-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden