Re: using dates in pgsql

Ron Johnson <ron.l.johnson@cox.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.

            regards, tom lane