monster query, how to make it smaller

Поиск
Список
Период
Сортировка
От juerg.rietmann@pup.ch
Тема monster query, how to make it smaller
Дата
Msg-id OF81AB8B38.22ACC82B-ONC12569DD.00504C90@pup.ch
обсуждение исходный текст
Ответы Re: monster query, how to make it smaller
Список 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
============================================
Вложения

В списке pgsql-sql по дате отправления:

Предыдущее
От: Volker Paul
Дата:
Сообщение: Re: select returns no line
Следующее
От: clayton cottingham
Дата:
Сообщение: [notion]: a possible language addition: XQL