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

Tom Lane wrote:

  Mladen Gogala <mgogala@vmsinfo.com> writes:


    There  have been some changes with that.



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



Yup, you're right:
scott=# set
standard_conforming_strings=true;
  SET
  Time: 0.689 ms
  scott=# select * from emp where ename like
'%' escape '\';
   empno | ename  |    job    | mgr  |     
hiredate       | sal  | comm | deptno
  -------+--------+-----------+------+---------------------+------+------+--------
    7369 | SMITH  | CLERK     | 7902 |
1980-12-17 00:00:00 |  800 |      |     20
    7499 | ALLEN  | SALESMAN  | 7698 |
1981-02-20 00:00:00 | 1600 |  300 |     30
    7521 | WARD   | SALESMAN  | 7698 |
1981-02-22 00:00:00 | 1250 |  500 |     30
    7566 | JONES  | MANAGER   | 7839 |
1981-04-02 00:00:00 | 2975 |      |     20
    7654 | MARTIN | SALESMAN  | 7698 |
1981-09-28 00:00:00 | 1250 | 1400 |     30
    7698 | BLAKE  | MANAGER   | 7839 |
1981-05-01 00:00:00 | 2850 |      |     30
    7782 | CLARK  | MANAGER   | 7839 |
1981-06-09 00:00:00 | 2450 |      |     10
    7788 | SCOTT  | ANALYST   | 7566 |
1987-04-19 00:00:00 | 3000 |      |     20
    7839 | KING   | PRESIDENT |      |
1981-11-17 00:00:00 | 5000 |      |     10
    7844 | TURNER | SALESMAN  | 7698 |
1981-09-08 00:00:00 | 1500 |    0 |     30
    7876 | ADAMS  | CLERK     | 7788 |
1987-05-23 00:00:00 | 1100 |      |     20
    7900 | JAMES  | CLERK     | 7698 |
1981-12-03 00:00:00 |  950 |      |     30
    7902 | FORD   | ANALYST   | 7566 |
1981-12-03 00:00:00 | 3000 |      |     20
    7934 | MILLER | CLERK     | 7782 |
1982-01-23 00:00:00 | 1300 |      |     10
  (14 rows)

  Time: 1.197 ms
  scott=# select version();

                                                   

version                    


                               

  --------------------------------------------------------------------------------
  --------------------------------
   PostgreSQL 8.4.4 on i686-redhat-linux-gnu,
compiled by GCC gcc (GCC) 4.1.2 2008
  0704 (Red Hat 4.1.2-46), 32-bit
  (1 row)

  Time: 0.736 ms
  scott=#




--
Mladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
www.vmsinfo.com