From: | Kenichiro Tanaka <ketanaka(at)ashisuto(dot)co(dot)jp> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: about scape characters |
Date: | 2010-07-15 01:13:43 |
Message-ID: | 4C3E60C7.40200@ashisuto.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello
I've used oracle for 10years,but I've never seen such notations.
In fact the SQL retuns an error .
<PostgreSQL>
postgres=# select E'\\';
?column?
----------
\
(1 row)
<ORACLE(10.2.0)>
SQL> select E'\\' from dual;
select E'\\' from dual
*
ERROR at line 1:
ORA-00923: FROM keyword not found where expected
--Of cource,this SQL works.
SQL> select '\\' from dual;
'\
--
\\
--or
SQL> set escape on
SQL> select '\\' from dual;
'
-
\
Sorry ,but I don't know SQLServer.
> 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.
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Stefan Kaltenbrunner | 2010-07-15 05:06:48 | Re: NASA needs Postgres - Nagios help |
Previous Message | Craig Ringer | 2010-07-15 01:05:23 | Re: Planner features, discussion |