Re: I was spoiled by the MySQL timestamp field

On Sun, Jan 26, 2003 at 05:00:36PM -0500, Tom Lane wrote:
> "Matthew Nuzum" <cobalt@bearfruit.org> writes:
> > The difference is when now() gets interpreted into a date.  Someone
> > please correct me if I'm wrong...

> now() is a function call and will not be folded into a constant.

I know it's not really related, but I think it might be worth noting
here, also, that now() is (was?  I don't have anything later than 7.2
handy for testing at the moment) resolves to the beginning of the
transaction.  If you need time to move forward during your
transaction, you need timeofday().

A


--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110