Re: I was spoiled by the MySQL timestamp field - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: I was spoiled by the MySQL timestamp field
Date
Msg-id 20030127180926.A9007@mail.libertyrms.com
Whole thread Raw
In response to Re: I was spoiled by the MySQL timestamp field  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Francisco Reyes
Date:
Subject: Status of tablespaces
Next
From: Andrew Sullivan
Date:
Subject: Re: pg_xlog safety