Resent-From: pete@piedmontdata.com
Resent-Date: Thu, 18 Mar 1999 16:38:45 -0500 (Eastern Daylight Time)
Resent-Message-Id: <199903182138.QAA00203@www.piedmontdata.com>
Message-ID: <36F17273.D1ABBC98@piedmontdata.com>
Date: Thu, 18 Mar 1999 16:39:00 -0500
From: Peter Andrews <pete@piedmontdata.com>
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: ODBC string insert problem
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

I am unable to insert the following string:

40'S?

into a varchar field through my ODBC driver.  The statement:

insert into test values('40\'S?');

works perfectly using psql, but when I execute it through the ODBC
driver, I get the following error message:

parse error at or near ""

In fact, my ODBC driver seems to do this whenever I attempt to insert a
string with a question mark after a single quote.  I am using PostgreSQL
6.4.2 and the Insight ODBC driver version 6.40.0004.  If anyone has run
into this before, I would greatly apprciate your help.

Peter Andrews