From: Bruce Momjian <pgman@candle.pha.pa.us>
Message-Id: <200311130447.hAD4ldZ23273@candle.pha.pa.us>
Subject: Re: [GENERAL] Postgres 7.4 : ECPG not Thread-safe
In-Reply-To: <200311131535.31388.philip@utiba.com>
To: Philip Yarra <philip@utiba.com>
Date: Wed, 12 Nov 2003 23:47:39 -0500 (EST)
Cc: PostgreSQL-interfaces <pgsql-interfaces@postgresql.org>
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII

Philip Yarra wrote:
> On Thu, 13 Nov 2003 03:16 pm, Bruce Momjian wrote:
> > Interfaces list, where is there detailed ecpg documentaiton, like
> > documentation on the AT clause?
> 
> I'm willing to have a go at updating the doco. Can someone point me to a guide 
> to getting started with the markup we use? 

Great, but be warned --- the work is huge.  Basically, ecpg is a full
ANSI SQL-standard C interface to PostgreSQL.  It is the only ANSI
standard application interface we support, I think.  Let me also add
that it is totally cool!  It doesn't look all that friendly, but once
you start coding in it, and pass variables in and out of queries, it
takes on amazing power and has amazing clarity.  If I was coding an app
in C, it would be the interface I would use.  libpq requires just too
much house-cleaning for me.

Anyway, I think you can grab any ANSI SQL enbedded document and get
ideas.  You can look at vendors docs because those are going to be very
similar, and you can look at the ANSI standard for ideas.  Of course,
check out what you see against our existing grammer to be sure we
support it, but once you are done, I think you could create a document
that really shows the power of ecpg --- right now, our docs don't do it
justice.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073