Re: [GENERAL] about scape characters

2010-07-14 Thread Kenichiro Tanaka
Hello I've used oracle for 10years,but I've never seen such notations. In fact the SQL retuns an error . postgres=# select E'\\'; ?column? -- \ (1 row) SQL> select E'\\' from dual; select E'\\' from dual * ERROR at line 1: ORA-00923: FROM keyword not found where expected

[GENERAL] about scape characters

2010-07-14 Thread Edmundo Robles L.
Hi!, maybe is a silly question but... Exists some syntax standard to escape especial characters on querys??? i mean, the notation E'\\ to escape especial characters only works in postgres (8.3.11) or this works on oracle, ms sql server too??? regards, eddie. -- Sent via pgsql-general mai