From: Michael Meskes <Michael_Meskes@topmail.de>
To: James Thompson <jamest@math.ksu.edu>
Cc: hoelc <hoelc@pd.jaring.my>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] question on accessing PostgreSQL with C
Date: Sun, 7 Feb 1999 20:03:46 +0100
Message-ID: <19990207200346.A254@gmx.net> (raw)
In-Reply-To: <Pine.GSO.4.05.9902061850530.6735-100000@noether.math.ksu.edu>
References: <36BCE221.47837890@pd.jaring.my>
<Pine.GSO.4.05.9902061850530.6735-100000@noether.math.ksu.edu>
On Sat, Feb 06, 1999 at 07:16:14PM -0600, James Thompson wrote:
> http://www.dal.ca/%7eoracle/oradoc/DOC/api/doc/PC_22/toc.htm
Gotta look at this.
> With it you end up with something like the following in your code
>
> exec sql
> insert into customer(id,name_first,name_middle,name_last,company,
> address1,address2,city,state,country,zip,phone_work,
> phone_home,phone_fax,email,date_entered,billing_terms,
> confirmation_method)
> values (:id,:name_first, :name_middle, :name_last,
> :company,:address1,:address2,
> :city,:state,:country,:zip,:phone_work,
> :phone_home,:phone_fax,:email,date('now'),
> :billing_terms,
> :confirmation_method);
Xou can even add indicators like in
... values (:id,:name_first, :name_middle:nm_ind, :name_last, ...
If nm_ind is set to -1 the name_middle entry will be set to NULL.
> The author of the code is very responsive to few problem reports I have
> sent him and has sent patches, or workarounds to me usually within 24
> hours.
Glad I can help. :-)
> In the few cases you can't figure out a way to make something happen using
> ecpg I believe you can mix the libpg and ecpg code in the same program.
> The only place I could see a need for this is when you'd need the
> functionality given by Pro*C's Dynamic SQL which ecpg doesn't yet support,
> but I think its in the works.
It is. In fact I already submitted a patch for the PREPARE and EXECUTE
commands. James, if you'd like to test this I can send you the source until
it makes its way into CVS.
Michael
--
Michael Meskes | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire!
Tel.: (+49) 2431/72651 | Use Debian GNU/Linux!
Email: Michael.Meskes@gmx.net | Use PostgreSQL!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: Michael_Meskes@topmail.de, jamest@math.ksu.edu, hoelc@pd.jaring.my
Subject: Re: [INTERFACES] question on accessing PostgreSQL with C
In-Reply-To: <19990207200346.A254@gmx.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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