pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Michael Meskes <meskes@postgresql.org>
To: Andrew S Halper <ashalper@usgs.gov>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: EXEC SQL INCLUDE syntax
Date: Mon, 20 Oct 2003 20:01:07 +0200
Message-ID: <20031020180107.GD2843@feivel.fam-meskes.de> (raw)
In-Reply-To: <20031017224220.GA1656@natasha.daztcn.wr.usgs.gov>
References: <20031017224220.GA1656@natasha.daztcn.wr.usgs.gov>

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/master_table.sc';
> 
> 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.

> Can anyone tell me what the ESQL standard says, and if there is an easy 

I thought that ecpg does implement the standard, but I haven't checked
it lately so I'm not sure.

> ecpg  work-around?

Other than changing the code, no. It seems we do need an Ingres
compatibility mode, too.

Michael
-- 
Michael Meskes
Email: Michael at Fam-Meskes dot De
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes@jabber.org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!



view thread (5+ messages)  latest in thread

Message-ID: <20031020180107.GD2843@feivel.fam-meskes.de>
Permalink:  ../20031020180107.GD2843@feivel.fam-meskes.de/
Also on:    postgresql.org/message-id/20031020180107.GD2843@feivel.fam-meskes.de

 · 

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 using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: meskes@postgresql.org, ashalper@usgs.gov
  Subject: Re: EXEC SQL INCLUDE syntax
  In-Reply-To: <20031020180107.GD2843@feivel.fam-meskes.de>

* 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