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 по дате отправления: