Between with a list of ranges possible ?

Поиск
Список
Период
Сортировка
От Arup Rakshit
Тема Between with a list of ranges possible ?
Дата
Msg-id 3240662.p6P6L5YxOV@linux-wzza.aruprakshit
обсуждение исходный текст
Ответы Re: Between with a list of ranges possible ?  (John R Pierce <pierce@hogranch.com>)
Re: Between with a list of ranges possible ?  (Andreas Kretschmer <akretschmer@spamfence.net>)
Re: Between with a list of ranges possible ?  (Raymond O'Donnell <rod@iol.ie>)
Re: Between with a list of ranges possible ?  (Stephen Cook <sclists@gmail.com>)
Список pgsql-general
Hi,

Can I do the below 3 queries in a single query  ?

select * from table where number * 3  between start_value1 and end_value2;
select * from table where number * 3  between start_value2 and end_value2;
select * from table where number * 3  between start_value3 and end_value3;


--
================
Regards,
Arup Rakshit
================
Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as
possible,you are, by definition, not smart enough to debug it. 

--Brian Kernighan


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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: [HACKERS] Re: 9.4.1 -> 9.4.2 problem: could not access status of transaction 1
Следующее
От: John R Pierce
Дата:
Сообщение: Re: Between with a list of ranges possible ?