Received: from epg-gw1.lewis.army.mil (epg-gw1.lewis.army.mil [150.192.56.10]) by hub.org (8.9.3/8.9.3) with SMTP id OAA15034 for ; Wed, 15 Sep 1999 14:23:00 -0400 (EDT) (envelope-from craig@epg-gw1.lewis.army.mil) Received: from delenn.eng by epg-gw1.lewis.army.mil with SMTP (1.37.109.4/15.6) id AA27016; Wed, 15 Sep 99 11:21:56 -0700 Received: by delenn.eng (8.7.6/16.2) id OAA10099; Wed, 15 Sep 1999 14:21:56 -0400 (EDT) Message-Id: X-Mailer: XFMail 1.3 [p0] on HP-UX (unknown) X-Priority: 3 (Normal) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit Mime-Version: 1.0 In-Reply-To: <199909131902.VAA06721@eunet.at> Date: Wed, 15 Sep 1999 11:21:55 -0700 (PDT) Reply-To: Craig Orsinger Organization: EPG Ft. Lewis Field Office Sender: craig@epg-gw1.lewis.army.mil From: Craig Orsinger To: pgsql-interfaces@postgreSQL.org Subject: RE: RE[2]: [INTERFACES] ecpg and getting just assigned serial nu 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: ) 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 ----------------------------------