Forum OpenACS Q&A: Re: postgresql syntax

Collapse
8: Re: postgresql syntax (response to 1)
Posted by Don Baccus on
Yes, please, use current_timestamp rather than switch to now(), which doesn't affect the type error in the expression.

PG used to treat integers in such expressions as being N days without the need to round off.  Also be wary of day roundoff issues in 7.2 it may be returning the date (i.e. no hour/minute/sec info) 14 days hence rather than 14*24 hours hence ...

Thanks for tackling these, Brad - e-mail me if you want cvs access to news directly and we can talk about getting your fixes into 4.6.4...