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