Re: [SQL] Newby Postgres questions

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
===================================================================