pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: pgsql-sql-digest V1 #422
2+ messages / 2 participants
[nested] [flat]

* Re: pgsql-sql-digest V1 #422
@ 1999-11-24 18:14 maxsbox <maxsbox@scds.co.za>
  1999-11-25 22:03 ` Re: [SQL] Re: pgsql-sql-digest V1 #422 Fabrice Scemama <fabrices@ximmo.ftd.fr>
  0 siblings, 1 reply; 2+ messages in thread

From: maxsbox @ 1999-11-24 18:14 UTC (permalink / raw)
  To: pgsql-sql@hub.org

>
>
> Date: Wed, 24 Nov 1999 09:09:51 +0530
> From: CHAITANYANC <CHAITANYANC@inf.com>
> 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





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: [SQL] Re: pgsql-sql-digest V1 #422
  1999-11-24 18:14 Re: pgsql-sql-digest V1 #422 maxsbox <maxsbox@scds.co.za>
@ 1999-11-25 22:03 ` Fabrice Scemama <fabrices@ximmo.ftd.fr>
  0 siblings, 0 replies; 2+ messages in thread

From: Fabrice Scemama @ 1999-11-25 22:03 UTC (permalink / raw)
  To: maxsbox <maxsbox@scds.co.za>; +Cc: pgsql-sql@hub.org

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 <CHAITANYANC@inf.com>
> > 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
> 
> ************



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~1999-11-25 22:03 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-11-24 18:14 Re: pgsql-sql-digest V1 #422 maxsbox <maxsbox@scds.co.za>
1999-11-25 22:03 ` Fabrice Scemama <fabrices@ximmo.ftd.fr>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox