Problem (bug?) wih like

Поиск
Список
Период
Сортировка
От bombadil@wanadoo.es
Тема Problem (bug?) wih like
Дата
Msg-id 20011203083736.A20115@fangorn.net
обсуждение исходный текст
Ответы Re: Problem (bug?) wih like  (DaVinci <bombadil@wanadoo.es>)
Re: Problem (bug?) wih like  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Problem (bug?) wih like  (DaVinci <davinci@escomposlinux.org>)
Список pgsql-general
 I'd like to contrast an error that I get when using like in text
 fields.

 I have a table A an a view v_A of A. Name is a text field (person
 names). Look at these queries:

 1)

     select * from A where name like '%DAVID%'

 It works pretty well and fast. Result:

     DAVID
    DAVID FOO
    DAVID
    .../...

 2)

     select * from v_A where name like '%DA%'

 It works too, with a result bigger (obviously) than first query.
 Result:

     DAVID
    DANIEL
    DAVID FOO
    .../...

 3)

     select * from v_A where name like '%DAVID%'

 It freezes psql. Why?. It seems a bug, doesn't it?. Thanks for any
 info.

                     David

В списке pgsql-general по дате отправления:

Предыдущее
От: "Clark C . Evans"
Дата:
Сообщение: Apache module for directory authorization
Следующее
От: "Yuri A. Kabaenkov"
Дата:
Сообщение: BEGIN, ROLLBACK,COMMIT