Problem (bug?) wih like

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

Responses

Browse pgsql-general by date

  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

Browse pgsql-hackers by date

  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