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

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group