Re: how to use aggregate functions in this case

Поиск
Список
Период
Сортировка
От Janek Sendrowski
Тема Re: how to use aggregate functions in this case
Дата
Msg-id trinity-d4cabe83-9e1d-490a-ae00-bec5fec8b15a-1377555064069@3capp-webde-bs37
обсуждение исходный текст
Ответ на Re: how to use aggregate functions in this case  (David Johnston <polobo@yahoo.com>)
Ответы Re: how to use aggregate functions in this case
Список pgsql-general
Hi,

 

thanks for all your answers.

I'll have a try with the contains operator and the intrange, but before I'd like to know if this would work:

 

CASE WHEN a >= 0 AND a < 25

CASE WHEN a >= 25 AND a < 50

 

There wouldn't be a double endpoint. I just have to decide which range the endpoint includes.

 

Janek Sendrowski

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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: Problem creating index
Следующее
От: David Johnston
Дата:
Сообщение: Re: how to use aggregate functions in this case