Received: from mail1.panix.com (mail1.panix.com [166.84.0.212]) by hub.org (8.8.8/8.7.5) with ESMTP id OAA24543 for ; Thu, 9 Jul 1998 14:12:21 -0400 (EDT) Received: from mailhost.nrnet.org (root@mailhost.nrnet.org [166.84.192.39]) by mail1.panix.com (8.8.8/8.8.8/PanixM1.3) with ESMTP id OAA09601; Thu, 9 Jul 1998 14:12:17 -0400 (EDT) Received: from localhost (tomg@localhost) by mailhost.nrnet.org (8.8.4/8.8.4) with SMTP id NAA00793; Thu, 9 Jul 1998 13:42:38 -0400 Date: Thu, 9 Jul 1998 13:42:38 -0400 (EDT) From: Tom Good To: Stephen Horton cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] Newby Postgres questions In-Reply-To: <199807091546.LAA05701@hub.org> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII 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 ===================================================================