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