On Thu, 2003-08-28 at 08:41, Tom Lane wrote:
> Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> writes:
> > On Wed, 2003-08-27 at 23:28, Tom Lane wrote:
> >> WHERE activedate < (CURRENT_DATE - 188)
>
> > How does pg know that that's 188 days, and not months or years?
>
> <shrug> ... that's what the "date - integer" operator is defined to do.
> If you want some other behavior, create another operator.
Oh, ok.
--
-----------------------------------------------------------------
Ron Johnson, Jr. ron(dot)l(dot)johnson(at)cox(dot)net
Jefferson, LA USA
"Object-oriented programming is an exceptionally bad idea which
could only have originated in California."
Edsger Dijkstra