Re: I was spoiled by the MySQL timestamp field

Lincoln Yeoh <lyeoh@pop.jaring.my>

From: Lincoln Yeoh <lyeoh@pop.jaring.my>
To: will trillich <will@serensoft.com>, pgsql-general@postgresql.org
Date: 2003-01-27T13:58:47Z
Lists: pgsql-general
At 11:59 PM 1/26/03 -0600, will trillich wrote:

>On Sun, Jan 26, 2003 at 05:00:36PM -0500, Tom Lane wrote:
> > now() is a function call and will not be folded into a constant.
>
> > You can easily check the behavior for yourself rather than relying on
> > other people's assertions.
>
>note -- this is ALWAYS a good idea. especially when it's *me*
>giving the assertion :)

It's still good hear from the developers what they think the behaviour 
should be, and would be.

If the devs, docs and software agree then it'll be fine to use the feature. 
Otherwise if possible, it might be a better idea to use a different feature 
to achieve what I want. Don't want to use a behaviour will soon be 
deprecated/changed.

Of course, it's not good to pester you guys for everything either. But 
current_timestamp vs now() vs 'now' would probably be a popular feature 
enough to clarify.

Hope this doesn't waste too much bandwidth ;).
Link.