monster query, how to make it smaller

From: juerg(dot)rietmann(at)pup(dot)ch
To: pgsql-sql(at)postgresql(dot)org
Subject: monster query, how to make it smaller
Date: 2001-01-23 14:42:10
Message-ID: OF81AB8B38.22ACC82B-ONC12569DD.00504C90@pup.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello everybody

I need some help on a monster query. Please see the attached file for the
query itself. The only difference is Z_durch_soll and the offset, which is
currently 0.25. The query will run in a loop where I increment this offset
until I find enough records.

Thanks in advance ... jr

(See attached file: monsterQuery.txt)

============================================
PFISTER + PARTNER, SYSTEM - ENGINEERING AG
Juerg Rietmann
Grundstrasse 22a
6343 Rotkreuz
Switzerland

phone: +4141 790 4040
fax: +4141 790 2545
mobile: +4179 211 0315
============================================

Attachment Content-Type Size
monsterQuery.txt application/octet-stream 3.1 KB

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message patrick.jacquot 2001-01-23 15:21:15 Re: select returns no line
Previous Message Volker Paul 2001-01-23 14:24:08 Re: select returns no line