Received: from ximmo.ftd.fr (XIMMO.FTD.FR [212.11.11.75]) by hub.org (8.9.3/8.9.3) with SMTP id PAA13808 for ; Thu, 25 Nov 1999 15:59:07 -0500 (EST) (envelope-from fabrices@ximmo.ftd.fr) Received: (qmail 4938 invoked by uid 531); 25 Nov 1999 22:03:31 -0000 Received: from localhost (HELO ximmo.ftd.fr) (127.0.0.1) by localhost with SMTP; 25 Nov 1999 22:03:31 -0000 Sender: gesnet Message-ID: <383DB232.302E0F52@ximmo.ftd.fr> Date: Thu, 25 Nov 1999 23:03:30 +0100 From: Fabrice Scemama X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.13 i686) X-Accept-Language: en MIME-Version: 1.0 To: maxsbox CC: pgsql-sql@hub.org Subject: Re: [SQL] Re: pgsql-sql-digest V1 #422 References: <199911240400.XAA58707@hub.org> <383C2AF1.B3A1C235@scds.co.za> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit The wheel does not have to be reinvented. Try perl's SQL::Statement . Fabrice Scemama maxsbox wrote: > > > > > > > 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 > > ************