Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: question about default value and timestamp
- From: "A. Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
- To: pgsql-general(at)postgresql(dot)org
- Subject: Re: question about default value and timestamp
- Date: Wed, 26 Jul 2006 07:42:26 +0200
am 26.07.2006, um 7:26:09 +0200 mailte Christian Rengstl folgendes: > Hi list, > > i have a table with a column where the default value is > current_timestamp, but somehow all the tuples (around 8.000.000) have > the same timestamp, which is, honestly speaking, not what i intended > to do. So is the current_timestamp function only executed when the > insert statement starts? I mean of course i can change it and insert No, but when the _Transaction_ starts. You can use timeofday() instead. HTH, Andreas -- Andreas Kretschmer (Kontakt: siehe Header) Heynitz: 035242/47215, D1: 0160/7141639 GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net === Schollglas Unternehmensgruppe ===
- References:
- question about default value and timestamp
- From: Christian Rengstl
- question about default value and timestamp
- Prev by Date: question about default value and timestamp
- Next by Date: Constraint on an aggregate? (need help writing trigger, i think..)
- Previous by thread: question about default value and timestamp
- Next by thread: Constraint on an aggregate? (need help writing trigger, i think..)
- Indexes: