On Wed, Jun 23, 2004 at 12:49:19PM +0200, Christian Kratzer wrote: > Hi, > > I have a stored procedure run periodically that assign accounting records > to their respective customers based on username and other criteria. > It also does all kinds of validation work on the accounting records. > > I would have liked to have the procedure log start and stop times > using RAISE NOTICE and also store start and stop time of each run > to a logging table.
<snip> > the problem is that start_time and stop_time are identical. > > Is there any way I can get plpgsql to reevaluate now at the end > of the batch ??? You want timeofday(), not now(). Now() is transaction time, timeofday() is the real current time. Hope this helps, -- Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/ > Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a > tool for doing 5% of the work and then sitting around waiting for someone > else to do the other 95% so you can sue them.
pgpnJuPthDjED.pgp
Description: PGP signature
