Richard Broersma Jr <rabroersma@xxxxxxxxx> writes: >> 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? If he casts all his dates to timestamps then this might be a good option. -- Jorge Godoy <jgodoy@xxxxxxxxx>