Re: [SQL] Newby Postgres questions - Mailing list pgsql-sql

From Tom Good
Subject Re: [SQL] Newby Postgres questions
Date
Msg-id Pine.LNX.3.95.980709133844.780A-100000@mailhost.nrnet.org
Whole thread Raw
In response to Newby Postgres questions  ("Stephen Horton" <shorton@nortel.ca>)
List pgsql-sql
On 9 Jul 1998, Stephen Horton wrote:

> Howdy list members,
>
> I'm new here and to Postgres.  I have 2 questions:
>
> 1.) Is there a list of the standard embedded SQL statements that Postgres
>     recognizes?  I'm coming from an Ingres background, and I've already scanned
>     over all of the docs.

No list exists, per se.  However, I have tried many of them and found
what works well and what requires some fiddling...I have a new man page
although as fast as Michael improves the code it is probably out of
date - and it's not even released yet ;-)

If you want I will send you the latest man page and be glad to answer any
questions I'm able to...the man page has examples of usage that I employ
in my code.

> 2.) Does Postgres support dynamic embedded sql (such as sqlda)?  I want to
>     dynamically construct SQL statements in my C code and have EGPC parse
>     the embedded SQL that contains variables for what my SQL statement will
>     be (at runtime, not compiletime).

I recall reading awhile back that it does not but I imagine that Michael
is working on it.

Cheers,
Tom G

===================================================================
        User Guide Dog Database Project
===================================================================
                  Powered by PostgreSQL 6.3.2
       * Advanced Database Design - Proven Performance *
                             ----
               Perl 5.004 / DBI-0.91::DBD-PG-0.69
===================================================================
                   http://www.panix.com/~ugd
===================================================================


pgsql-sql by date:

Previous
From: Jeff Aitken
Date:
Subject: Re: [SQL] Single vs. multiple indexes
Next
From: Bruce Momjian
Date:
Subject: Re: [SQL] Single vs. multiple indexes