> edipoelder(at)ig(dot)com(dot)br writes:
> > It doesn't getting different times on each execution. I also tried put
> > "timestamp 'now'" insted "now()". What am I doing wrong?
>
> now() is defined to return the time of the start of the current
> transaction. It won't change value inside a transaction. See
> http://www.postgresql.org/devel-corner/docs/postgres/functions-datetime.html#FUNCTIONS-DATETIME-CURRENT
What about CURRENT_TIMESTAMP? (This is standard SQL isn't it?)