Christoph Haller wrote:
> Hi pgsql-sql list,
> I did some testing around tables using a column
> timestamp with time zone not null default now().
> I have noticed a valuable feature:
> As long as being inside a transaction initiated by
> the return value of the now() function does not change.
> Is this intended - as written in the documentation?
> Can I rely on it, so future releases of PostgreSQL
> will act the same.
Yes, this is intended and will not change.
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
In response to
pgsql-sql by date
|Next:||From: Tom Lane||Date: 2002-04-18 16:15:43|
|Subject: Re: SQL Query Optimization |
|Previous:||From: Josh Berkus||Date: 2002-04-18 15:43:53|
|Subject: Re: SQL Query Optimization|