Re: I need a jump start

On Tue, May 15, 2001 at 08:36:59PM -0700, Scott Holmes wrote:
> I need to write a C program that will require libpq and ecpg.  I'm hoping 
> someone can point me to an example.  I'm not a C programmer, so I need a crash 
> course or jump start.  The original program has existed as an Informix 4GL 
> program for many years.  We have lately been converting our application to 
> PostgreSQL.  All the user interfaces have been written with a rather obscure 
> set of tools to be run on Windows clients.  This particular program needs to 
> be run with cron on the server.  Essentially, it will scan a relatively short 
> list of records, compare values with records or tuples from a relatively large 
> table then insert into and or update other tables.  Interestingly enough, the 
> first table's name is trigger.  As most of the actions required are time 
> delayed (days or weeks), triggers are not a viable option for this.
> 
> Does anyone have a suggestion for an existing program or code I can study to 
> give myself a leg up on this?

Maybe a plpgsql function and a shell script would be easier for you?
Sounds like most of the work can be done by PostgreSQL itself with
standard SQL and a few flow control mechanisms (like in plpgsql).
Anyway, there are some examples in the programming manual for all of the
above...

-- 
Eric G. Miller <egm2@jps.net>