Re: Date Parameter To Query Confusing Optimizer

In response to "Kurt Westerfeld" <kwesterfeld@novell.com>:
> >>> Radosław Smogura<rsmogura@softperience.eu> 1/4/2011 9:48 AM >>>
> Can You try "...BETWEEN ?::date and ?::date ..." syntax or send
> statement causing problems?
>
> As for the BETWEEN clause, I'm using hibernate and don't want to put a database-specific SQL query in place.

You could do "BEWTEEN CAST(? AS DATE) AND CAST(? AS DATE)" and it wouldn't
be database-specific.

You might also want to consider top-posting.  I'm not sure why I read enough
of this to understand it, as I usually get confused an frustrated when
things have been top posted and stop reading.

--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/