performance.
Regards,
R.Muralidharan
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED]
Sent: Tuesday, May 03, 2005 5:45 PM
To: CHRIS HOOVER
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Record Log Trigger
Well...
Right, I will use to_timestamp
Well...
Right, I will use to_timestamp() function instead of now() function.
But, what is the performance for those Triggers??? Considering that all tables
will have this Trigger and will check for each update or insert.
Thanks
Quoting CHRIS HOOVER <[EMAIL PROTECTED]>:
One change you might want to
One change you might want to look at is not using the now() function.
According to the docs, the now() function always returns the start of the
transaction time. So, if your code is using transaction blocks, the time may
not be what you are expecting.
This is what I had do to in my trigger to get
