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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org/

Reply via email to