Skip site navigation (1) Skip section navigation (2)

Re: [INTERFACES] question on accessing PostgreSQL with C

From: hoelc <hoelc(at)pd(dot)jaring(dot)my>
To: Michael Meskes <Michael_Meskes(at)topmail(dot)de>
Cc: James Thompson <jamest(at)math(dot)ksu(dot)edu>, pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] question on accessing PostgreSQL with C
Date: 1999-02-10 03:31:15
Message-ID: 36C0FD83.3A2C2F0A@pd.jaring.my (view raw or flat)
Thread:
Lists: pgsql-interfaces
Hello,
Thanks a lot.
I have a PostgreSQL-6.2.1 ( in RedHat Linux 5.0), and it doesn't has "ecpg".
I have downloaded "ecpg" from internet, but don't know how to install it into my
PostgreSQL system.  Please advise.

Thank you very much.
Regards.....LCH

Michael Meskes wrote:

> 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(dot)Meskes(at)gmx(dot)net          | Use PostgreSQL!




In response to

Responses

pgsql-interfaces by date

Next:From: Rudhuwan Abu BakarDate: 1999-02-10 04:03:32
Subject: Applix Data and Postgresql
Previous:From: Joshua IntroneDate: 1999-02-10 03:14:48
Subject: JDBC driver returns NullPointerException on getObject

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group