On Jul 2, 2007, at 18:26 , Paul Lambert wrote:
Looks like it's a toss-up between turning
standard_conforming_strings on or turning escape_string_warning
off, both seem to have the same effect in not giving the error
anymore.
A warning is not an error :)
Michael Glaesemann
grzm seespotco
Michael Glaesemann wrote:
On Jul 2, 2007, at 17:45 , Paul Lambert wrote:
tester=# insert into testing (test_text) values ('abcE'\\'123');
This should be
INSERT INTO testing (test_text) values (E'abc\123');
The help itself (ch 4.1.2.1) tells me to use double backslash "Thus,
to include a ba
On Jul 2, 2007, at 17:45 , Paul Lambert wrote:
tester=# insert into testing (test_text) values ('abcE'\\'123');
This should be
INSERT INTO testing (test_text) values (E'abc\123');
The help itself (ch 4.1.2.1) tells me to use double backslash
"Thus, to include a backslash character, write t
I'm having a little glitch in using escape strings within strings.
The following will best explain my issue:
tester=# create table testing (test_text text);
CREATE TABLE
tester=# insert into testing (test_text) values ('abc\\123');
WARNING: nonstandard use of \\ in a string literal
LINE 1: ins
Hi everybody,
I have the following 3 tables:
sent_messages
uid | receiver| theme| date
-+--+-+---
1 | +40741775630 | CAND1 | 2007-06-12 14:06:57.843024+00
2 | +40741775630 | MAMA | 2007-06-12 14:07: