Re: [GENERAL] Between with a list of ranges possible ?

[John R Pierce]

On 5/29/2015 9:32 AM, Arup Rakshit wrote:

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;

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





--
john r pierce, recycling bits in santa cruz



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general