Backslashes in 8.2 still escape, hwo to disable?
Hi,
I'm trying out the new 8.2 beta; the following query:
select 'ab\cd'; yields: abcd, not ab\cd.
Is there a setting I'd need to switch to enable the ANSI/ISO escape
behavior? I am using the JDBC driver; not sure if that could be the
culprit..
Thanks,
Ken
On Fri, 2006-09-29 at 18:12 -0600, Ken Johanson wrote:
Hi,
I'm trying out the new 8.2 beta; the following query:
select 'ab\cd'; yields: abcd, not ab\cd.
Is there a setting I'd need to switch to enable the ANSI/ISO escape
behavior? I am using the JDBC driver; not sure if that could be the
culprit..
standard_conforming_strings
Regards,
Jeff Davis
You guys, and PG ROCK!! The standard_conforming_strings mode works
beautifully... it is (was) the last low-level barrier to using PG in a
really professional/interop environment. And as I become familiar,
again, with how PG and it's tools have come along, I am SUPER impressed.
Many, many kudos!! Top notch!!
Ken
Ken Johanson wrote:
You guys, and PG ROCK!! The standard_conforming_strings mode works
beautifully... it is (was) the last low-level barrier to using PG in a
really professional/interop environment. And as I become familiar,
again, with how PG and it's tools have come along, I am SUPER impressed.
Yea, we figured standard_conforming_strings was going to be needed badly
in certain environments.
--
Bruce Momjian bruce@momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +