Re: select ... where <column>='' does a seqscan [auf Viren geprueft]

Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Text Size: Normal / Large
Donate
Contact

The world's most advanced open source database.

Re: select ... where <column>='' does a seqscan [auf Viren geprueft]

From:	Peter Eisentraut <peter_e(at)gmx(dot)net>
To:	Silvio Matthes <silvio(dot)matthes(at)xcom(dot)de>
Cc:	pgsql-general(at)postgresql(dot)org
Subject:	Re: select ... where <column>='' does a seqscan [auf Viren geprueft]
Date:	2004-08-24 13:04:40
Message-ID:	200408241504.40569.peter_e@gmx.net (view raw or flat)
Thread:
Lists:	pgsql-general

Am Dienstag, 24. August 2004 11:59 schrieb Silvio Matthes:
> So using the index does need more time than a sequential scan?

It's possible.  If you want to prove the opposite, please post the output of 
EXPLAIN ANALYZE in both cases.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/

In response to

select ... where <column>='' does a seqscan [auf Viren geprueft] at 2004-08-24 09:59:45 from Silvio Matthes

pgsql-general by date

Next: From: Eduardo S. Fontanetti Date: 2004-08-24 13:40:32

Subject: Dump and Restore

Previous: From: Jerry Sievers Date: 2004-08-24 12:23:14

Subject: Re: Possible to insert quoted null value into integer field?

Next:	From: Eduardo S. Fontanetti	Date: 2004-08-24 13:40:32
	Subject: Dump and Restore
Previous:	From: Jerry Sievers	Date: 2004-08-24 12:23:14
	Subject: Re: Possible to insert quoted null value into integer field?

Search

Peripheral Links

Re: select ... where <column>='' does a seqscan [auf Viren geprueft]

In response to

pgsql-general by date