[GENERAL] Backslashes in 8.2 still escape, hwo to disable?

2006-09-29 Thread Ken Johanson 

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



---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Backslashes in 8.2 still escape, hwo to disable?

2006-09-29 Thread Jeff Davis 
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


---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org