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


From: Andrew S Halper <ashalper(at)usgs(dot)gov>
To: Michael Meskes <meskes(at)postgresql(dot)org>
Cc: Andrew S Halper <ashalper(at)usgs(dot)gov>,pgsql-interfaces(at)postgresql(dot)org
Subject: Re: EXEC SQL INCLUDE syntax
Date: 2003-10-20 20:50:08
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces
On 2003.10.20 11:01, Michael Meskes wrote:
> On Fri, Oct 17, 2003 at 03:42:20PM -0700, Andrew S Halper wrote:
> > I'm trying to port some Ingres code to PostgreSQL.  For Ingres, I had this
> > bit  of ESQL:
> >
> > EXEC SQL INCLUDE '../dcl/';
> >
> > which ecpg (2.10.0) can't digest with single quotes, and Ingres (2.5)  
> esqlc
> > can't digest without single quotes.
> ecpg only accepts double quotes or no quote at all.

Changing the single quotes to double quotes worked with the Ingres  
preprocessor, but not with ecpg:

natasha:~/nwis-4.4/common/db/midas-tools> ls -l
-rw-r--r--    1 ashalper nwdba         158 Oct 20 13:46
natasha:~/nwis-4.4/common/db/midas-tools> ecpg ERROR: Cannot open include file "" in line 37


In response to


pgsql-interfaces by date

Next:From: Michael MeskesDate: 2003-10-21 07:47:17
Subject: Re: EXEC SQL INCLUDE syntax
Previous:From: Michael MeskesDate: 2003-10-20 18:01:07
Subject: Re: EXEC SQL INCLUDE syntax

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