pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Craig Orsinger <orsingerc@epg-gw1.lewis.army.mil>
To: pgsql-interfaces@postgreSQL.org
Subject: RE: RE[2]: [INTERFACES] ecpg and getting just assigned serial nu
Date: Wed, 15 Sep 1999 11:21:55 -0700 (PDT)
Message-ID: <XFMail.990915112155.orsingerc@epg-gw1.lewis.army.mil> (raw)
In-Reply-To: <199909131902.VAA06721@eunet.at>


On 13-Sep-99 Theofilu Andreas wrote:
>> to do. Anything else and it gets really difficult. While Informix
>> supports EXEC SQL IFDEF, PostgreSQL does not appear to.
>> 
> It is not always easy to do that and the two are different, but not
> completely. However. I use a special preprocessor (lwpp [look at freshmeat
> for it]) to create an embedded C file for PostgreSQL 'ecpg' or Informix
> 'esqlc'. I think this is the better way. Having two source trees would mean
> to do everything twice and if I forget something I have two incompatible
> programs.

        I downloaded this program and tried it out. It definitely
has possibilities. I especially like its flexible prefix feature,
which should make it possible to use for source files in just 
about any language. You could use this, for instance, to pre-process
SQL scripts for different DBMSs. I've been doing stuff like this
using sed scripts in makefiles, and I can tell you I'd much rather
do it this way.

        Thanks for the tip.


----------------------------------
Date: 15-Sep-99  Time: 11:10:52

Craig Orsinger                  (email: <orsingerc@epg-gw1.lewis.army.mil>)
Logicon RDA
Bldg. 8B28                      "Just another megalomaniac with ideas above his
6th & F Streets                 station. The Universe is full of them."
Ft. Lewis, WA   98433                   - The Doctor
----------------------------------



view thread (2+ messages)

Message-ID: <XFMail.990915112155.orsingerc@epg-gw1.lewis.army.mil>
Permalink:  ../XFMail.990915112155.orsingerc@epg-gw1.lewis.army.mil/
Also on:    postgresql.org/message-id/XFMail.990915112155.orsingerc@epg-gw1.lewis.army.mil

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: orsingerc@epg-gw1.lewis.army.mil, pgsql-interfaces@postgreSQL.org
  Subject: Re: [INTERFACES] ecpg and getting just assigned serial nu
  In-Reply-To: <XFMail.990915112155.orsingerc@epg-gw1.lewis.army.mil>
  References: <199909131902.VAA06721@eunet.at> <XFMail.990915112155.orsingerc@epg-gw1.lewis.army.mil>

* 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