monster query, how to make it smaller - Mailing list pgsql-sql

From juerg.rietmann@pup.ch
Subject monster query, how to make it smaller
Date
Msg-id OF81AB8B38.22ACC82B-ONC12569DD.00504C90@pup.ch
Whole thread Raw
Responses Re: monster query, how to make it smaller
List 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

pgsql-sql by date:

Previous
From: Volker Paul
Date:
Subject: Re: select returns no line
Next
From: clayton cottingham
Date:
Subject: [notion]: a possible language addition: XQL