Re: The escape clause in the SELECT statement in PostgreSQL 8.4

From: Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Mladen Gogala <mgogala(at)vmsinfo(dot)com>, Sheng Hui <w9510055(at)hotmail(dot)com>, "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: The escape clause in the SELECT statement in PostgreSQL 8.4
Date: 2010-06-08 00:51:44
Message-ID: 4C0D9420.5010500@vmsinfo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Tom Lane wrote:
<blockquote cite="mid:22947(dot)1275952224(at)sss(dot)pgh(dot)pa(dot)us" type="cite">
<pre wrap="">Mladen Gogala <a class="moz-txt-link-rfc2396E" href="mailto:mgogala(at)vmsinfo(dot)com">&lt;mgogala(at)vmsinfo(dot)com&gt;</a> writes:
</pre>
<blockquote type="cite">
<pre wrap="">There have been some changes with that.
</pre>
</blockquote>
<pre wrap=""><!---->
Not since 8.2. It looks to me like the OP had
standard_conforming_strings turned on in his 8.2 installation
and forgot to duplicate that setting in 8.4.

regards, tom lane

</pre>
</blockquote>
Yup, you're right:<br>
<blockquote><tt><font color="#3333ff">scott=# set
standard_conforming_strings=true;</font></tt><br>
<tt><font color="#3333ff">SET</font></tt><br>
<tt><font color="#3333ff">Time: 0.689 ms</font></tt><br>
<tt><font color="#3333ff">scott=# select * from emp where ename like
'%' escape '\';</font></tt><br>
<tt><font color="#3333ff">&nbsp;empno | ename&nbsp; |&nbsp;&nbsp;&nbsp; job&nbsp;&nbsp;&nbsp; | mgr&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
hiredate&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | sal&nbsp; | comm | deptno </font></tt><br>
<tt><font color="#3333ff">-------+--------+-----------+------+---------------------+------+------+--------</font></tt><br>
<tt><font color="#3333ff">&nbsp; 7369 | SMITH&nbsp; | CLERK&nbsp;&nbsp;&nbsp;&nbsp; | 7902 |
1980-12-17 00:00:00 |&nbsp; 800 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 20</font></tt><br>
<tt><font color="#3333ff">&nbsp; 7499 | ALLEN&nbsp; | SALESMAN&nbsp; | 7698 |
1981-02-20 00:00:00 | 1600 |&nbsp; 300 |&nbsp;&nbsp;&nbsp;&nbsp; 30</font></tt><br>
<tt><font color="#3333ff">&nbsp; 7521 | WARD&nbsp;&nbsp; | SALESMAN&nbsp; | 7698 |
1981-02-22 00:00:00 | 1250 |&nbsp; 500 |&nbsp;&nbsp;&nbsp;&nbsp; 30</font></tt><br>
<tt><font color="#3333ff">&nbsp; 7566 | JONES&nbsp; | MANAGER&nbsp;&nbsp; | 7839 |
1981-04-02 00:00:00 | 2975 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 20</font></tt><br>
<tt><font color="#3333ff">&nbsp; 7654 | MARTIN | SALESMAN&nbsp; | 7698 |
1981-09-28 00:00:00 | 1250 | 1400 |&nbsp;&nbsp;&nbsp;&nbsp; 30</font></tt><br>
<tt><font color="#3333ff">&nbsp; 7698 | BLAKE&nbsp; | MANAGER&nbsp;&nbsp; | 7839 |
1981-05-01 00:00:00 | 2850 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 30</font></tt><br>
<tt><font color="#3333ff">&nbsp; 7782 | CLARK&nbsp; | MANAGER&nbsp;&nbsp; | 7839 |
1981-06-09 00:00:00 | 2450 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 10</font></tt><br>
<tt><font color="#3333ff">&nbsp; 7788 | SCOTT&nbsp; | ANALYST&nbsp;&nbsp; | 7566 |
1987-04-19 00:00:00 | 3000 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 20</font></tt><br>
<tt><font color="#3333ff">&nbsp; 7839 | KING&nbsp;&nbsp; | PRESIDENT |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |
1981-11-17 00:00:00 | 5000 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 10</font></tt><br>
<tt><font color="#3333ff">&nbsp; 7844 | TURNER | SALESMAN&nbsp; | 7698 |
1981-09-08 00:00:00 | 1500 |&nbsp;&nbsp;&nbsp; 0 |&nbsp;&nbsp;&nbsp;&nbsp; 30</font></tt><br>
<tt><font color="#3333ff">&nbsp; 7876 | ADAMS&nbsp; | CLERK&nbsp;&nbsp;&nbsp;&nbsp; | 7788 |
1987-05-23 00:00:00 | 1100 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 20</font></tt><br>
<tt><font color="#3333ff">&nbsp; 7900 | JAMES&nbsp; | CLERK&nbsp;&nbsp;&nbsp;&nbsp; | 7698 |
1981-12-03 00:00:00 |&nbsp; 950 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 30</font></tt><br>
<tt><font color="#3333ff">&nbsp; 7902 | FORD&nbsp;&nbsp; | ANALYST&nbsp;&nbsp; | 7566 |
1981-12-03 00:00:00 | 3000 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 20</font></tt><br>
<tt><font color="#3333ff">&nbsp; 7934 | MILLER | CLERK&nbsp;&nbsp;&nbsp;&nbsp; | 7782 |
1982-01-23 00:00:00 | 1300 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 10</font></tt><br>
<tt><font color="#3333ff">(14 rows)</font></tt><br>
<br>
<tt><font color="#3333ff">Time: 1.197 ms</font></tt><br>
<tt><font color="#3333ff">scott=# select version();</font></tt><br>
<tt><font color="#3333ff">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
version&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </font></tt><br>
<tt><font color="#3333ff">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </font></tt><br>
<tt><font color="#3333ff">--------------------------------------------------------------------------------</font></tt><br>
<tt><font color="#3333ff">--------------------------------</font></tt><br>
<tt><font color="#3333ff">&nbsp;PostgreSQL 8.4.4 on i686-redhat-linux-gnu,
compiled by GCC gcc (GCC) 4.1.2 2008</font></tt><br>
<tt><font color="#3333ff">0704 (Red Hat 4.1.2-46), 32-bit</font></tt><br>
<tt><font color="#3333ff">(1 row)</font></tt><br>
<br>
<tt><font color="#3333ff">Time: 0.736 ms</font></tt><br>
<tt><font color="#3333ff">scott=# </font></tt><br>
</blockquote>
<br>
<br>
<br>
<pre class="moz-signature" cols="72">--
Mladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
<a class="moz-txt-link-abbreviated" href="http://www.vmsinfo.com">www.vmsinfo.com</a>
</pre>
</body>
</html>

Attachment Content-Type Size
unknown_filename text/html 5.7 KB

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Mladen Gogala 2010-06-08 02:41:54 The Two Towers
Previous Message Tom Lane 2010-06-07 23:10:24 Re: The escape clause in the SELECT statement in PostgreSQL 8.4