Received: from ps2.scds.co.za (IDENT:root@unknown.scds.IAFRICA.NET [196.31.108.20] (may be forged)) by hub.org (8.9.3/8.9.3) with ESMTP id OAA02536 for ; Thu, 25 Nov 1999 14:38:57 -0500 (EST) (envelope-from maxsbox@scds.co.za) Received: from scds.co.za ([196.14.24.75]) by ps2.scds.co.za (8.8.7/8.8.0) with ESMTP id VAA13029 for ; Thu, 25 Nov 1999 21:38:41 +0200 Message-ID: <383C2AF1.B3A1C235@scds.co.za> Date: Wed, 24 Nov 1999 20:14:11 +0200 From: maxsbox X-Mailer: Mozilla 4.5 [en] (Win95; I) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@hub.org Subject: Re: pgsql-sql-digest V1 #422 References: <199911240400.XAA58707@hub.org> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit > > > Date: Wed, 24 Nov 1999 09:09:51 +0530 > From: CHAITANYANC > Subject: Info on SQL Parsing required > > 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 > > ------------------------------ Not that this really answers your question, but:- Have a look at Paradox, I'm using version 8. It allows you to query either an SQL data base or the .db and .dbf files using either an SQL or a QBE query. I was rather surprised to find that a QBE query would work from it accessing postgreSQL using ODBC. Found, for a script, the SQL query had more flexibility, however, as it allows greater use of variables in the query, particularly where you want to substitute a variable for a file name. Hope this helps you Regards Max Wood