"Jacques Gollion" <[EMAIL PROTECTED]> writes: > The following functions returns the first time the right date and time but > when called at several date and time returns the date that was returned at > the first call.
Please read http://www.postgresql.org/docs/8.1/static/functions-datetime.html#FUNCTIONS-DATETIME-CURRENT > To get again the right date, it is necessary do disconnect and reconnect. A fresh transaction is sufficient. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend