> 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.
