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: | Raw Message | Whole Thread | 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 |