At 11:13 AM 3/29/2001 -0600, you wrote:
>i'd agree with you.
>
>but as tom lane mentioned, current_date is today, all day, until
>midnight (local time zone, i presume) whereas current_timestamp
>is less chunky, having finer grains down to one second.
>
>but even there, the timestamp is apparently (just learned this
>today from other posts on this thread) set for the start of the
>current transaction (or is it session?)...
>
>timeofday() may be what you're after.
I'm new to stored procedures, triggers and pl/pgsql. The mistakes I'll
likely make will be simple ones and I should have thought of timestamp vs.
date, sorry to ask such foolish questions.
