On Fri, 19 Aug 2005, CSN wrote:
> Hi,
>
> I suggestion for the date/time functions in the docs:
> http://www.postgresql.org/docs/8.0/interactive/functions-datetime.html
>
> I was trying to figure out how to do:
> update table set next=now() + interval 'table.period
> seconds';
>
> I tried subquer
On Wed, 29 Sep 2004, Tom Lane wrote:
> "Thomas F.O'Connell" <[EMAIL PROTECTED]> writes:
> > I'm thinking something like this (with thanks to Stephan):
>
> > Note: EXTRACT is not a true function. SQL defines it as an expression
> > that happens to look similar to a function call.
>
> Rather than do