On Mon, Jan 23, 2006 at 11:40:43AM +0000, Jacques Gollion wrote: > 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.
See "Current Date/Time" in the documentation: http://www.postgresql.org/docs/8.1/interactive/functions-datetime.html#FUNCTIONS-DATETIME-CURRENT "It is important to know that CURRENT_TIMESTAMP and related functions return the start time of the current transaction; their values do not change during the transaction. This is considered a feature: the intent is to allow a single transaction to have a consistent notion of the 'current' time, so that multiple modifications within the same transaction bear the same time stamp." "There is also the function timeofday() which returns the wall-clock time and advances during transactions." > To get again the right date, it is necessary do disconnect and reconnect. Do you have autocommit disabled? I'd guess all of your function calls are happening in the same transaction. You shouldn't have to reconnect; starting a new transaction should work. -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly