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
