Re: EXEC SQL INCLUDE syntax

From: Michael Meskes <meskes(at)postgresql(dot)org>
To: Andrew S Halper <ashalper(at)usgs(dot)gov>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: EXEC SQL INCLUDE syntax
Date: 2003-10-20 18:01:07
Message-ID: 20031020180107.GD2843@feivel.fam-meskes.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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(at)jabber(dot)org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!

In response to

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Andrew S Halper 2003-10-20 20:50:08 Re: EXEC SQL INCLUDE syntax
Previous Message Andrew S Halper 2003-10-17 22:42:20 EXEC SQL INCLUDE syntax