Re: Between with a list of ranges possible ?

[Stephen Cook <sclists@xxxxxxxxx>]

Use UNION ALL:

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


-- Stephen

On 5/29/2015 12:32 PM, Arup Rakshit wrote:
> 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;



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