pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: 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>
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-25 22:03 Fabrice Scemama <fabrices@ximmo.ftd.fr>
parent: maxsbox <maxsbox@scds.co.za>
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