> In my application second and fourth parameters can be NULL which means
> forever.
> It this best solution ?
> How many times this is slower than expression in where clause?
I am not sure if this would work for you, but instead of using NULL to represent infinity, why not
use 'infinity' to represent infinity?
logs=# select 'infinity'::timestamp;
timestamp
-----------
infinity
(1 row)
Regards,
Richard Broersma Jr.