Re: Problem with query

Поиск
Список
Период
Сортировка
От Fernando Hevia
Тема Re: Problem with query
Дата
Msg-id AANLkTimzh7jDSDAR+ow=ss8Pqx_Uu54xXKJaWkt1oWt5@mail.gmail.com
обсуждение исходный текст
Ответ на Problem with query  (Barbara Woolums <barb.woolums@ymail.com>)
Список pgsql-performance
Дерево обсуждения


On Sat, Jan 15, 2011 at 14:56, Barbara Woolums <barb.woolums@ymail.com> wrote:
Hi there,

Could someone please tell me why the following query won't work

select DISTINCT get_unit(unit) as unit, get_ingredient(ing) as ing, get_ing_aisle(1,ing) as aisle
from recipe_ing where recipe in(1084, 1086, 1012, 618) and qtydec>0 and ing not in(select ing from excluded_ing where owner=1)
order by aisle

 
 
You seem to be mixing up the parameters for get_ing_aisle.
Try get_ing_aisle(ing,1) as aisle instead
 

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

Предыдущее
От: Mladen Gogala
Дата:
Сообщение: Re: Possible to improve query plan?
Следующее
От: Achilleas Mantzios
Дата:
Сообщение: Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2