| From: | bombadil(at)wanadoo(dot)es |
|---|---|
| To: | Lista PostgreSql <pgsql-general(at)postgresql(dot)org> |
| Subject: | Problem (bug?) wih like |
| Date: | 2001-12-03 07:37:36 |
| Message-ID: | 20011203083736.A20115@fangorn.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | DaVinci | 2001-12-03 08:13:02 | Re: Problem (bug?) wih like |
| Previous Message | Yuri A. Kabaenkov | 2001-12-03 07:35:45 | BEGIN, ROLLBACK,COMMIT |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | DaVinci | 2001-12-03 08:13:02 | Re: Problem (bug?) wih like |
| Previous Message | Tom Lane | 2001-12-03 01:01:14 | Re: configuration files and PGDATA variable |