Query with multiples operators BETWEEN

From: Renaud Tthonnart <thonnart(at)amwdb(dot)u-strasbg(dot)fr>
To: pgsql-general(at)postgresql(dot)org
Subject: Query with multiples operators BETWEEN
Date: 2001-02-22 16:10:51
Message-ID: 3A953A0B.14D004@amwdb.u-strasbg.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


This qwery takes about 2 seconds :

SELECT e.name
FROM Observation o, Exposure_EPIC e
WHERE o.numObs = e.obs
AND e.instrPN IS NOT NULL
AND o.RA BETWEEN 3 AND 5;

This one about 5 seconds :

SELECT e.name
FROM Observation o, Exposure_EPIC e
WHERE o.numObs = e.obs
AND e.instrPN IS NOT NULL
AND o.DE BETWEEN 2 AND 7;

And this takes a lot of time!!!! (I can't say how much because I 've
always given it up before its end,
at least
more than 10 minutes)

SELECT e.name
FROM Observation o, Exposure_EPIC e
WHERE o.numObs = e.obs
AND e.instrPN IS NOT NULL
AND o.RA BETWEEN 3 AND 5
AND o.DE BETWEEN 2 AND 7;

Could someone help or explain me?

Thanks in advance and excuse my bad English
Renaud THONNART

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Neil Conway 2001-02-22 16:23:20 Re: Query with multiples operators BETWEEN
Previous Message Louis-David Mitterrand 2001-02-22 15:44:23 iterating over all NEW.* values in a trigger?