Between with a list of ranges possible ? - Mailing list pgsql-general

From Arup Rakshit
Subject Between with a list of ranges possible ?
Date
Msg-id 3240662.p6P6L5YxOV@linux-wzza.aruprakshit
Whole thread Raw
Responses 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>)
List 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 by date:

Previous
From: Robert Haas
Date:
Subject: Re: [HACKERS] Re: 9.4.1 -> 9.4.2 problem: could not access status of transaction 1
Next
From: John R Pierce
Date:
Subject: Re: Between with a list of ranges possible ?