Problem (bug?) wih like

Поиск
Список
Период
Сортировка
От bombadil@wanadoo.es
Тема Problem (bug?) wih like
Дата
Msg-id 20011203083736.A20115@fangorn.net
обсуждение исходный текст
Ответы Re: Problem (bug?) wih like
Re: Problem (bug?) wih like
Re: Problem (bug?) wih like
Список 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 по дате отправления: