Re: Efficiency in Multiple Queries of Same Table in a PL/PgSQL Function

Поиск
Список
Период
Сортировка
От Gary Chambers
Тема Re: Efficiency in Multiple Queries of Same Table in a PL/PgSQL Function
Дата
Msg-id 302670f20910191454r4faef8f7m78b5218e6e6a5788@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Efficiency in Multiple Queries of Same Table in a PL/PgSQL Function  (Rob Sargent <robjsargent@gmail.com>)
Список pgsql-sql
> But if I read the OP correctly the sigma are in fact used additively in each
> row in blah.  "sigma_* = sigma_* +"

I apologize, but I omitted a CASE statement prior to each calculation
of the values.  The coefficients for each calculation change depending
upon which case is valid.  I could probably rewrite it using arrays
and may, in fact, do so to eliminate the two added queries.  Thank you
for your input.

-- Gary Chambers

/* Nothing fancy and nothing Microsoft! */


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: How to order varchar data by word
Следующее
От: Andrew Hall
Дата:
Сообщение: Dynamic Query