Обсуждение: question about default value and timestamp
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 functiononly executed when the insert statement starts? I mean of course i can change it and insert the current_timestampexplicitly in every tuple, i just would like to know why it doesn't work the way i wanted it to work... Thanks! Chris -- Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung Universitätsklinikum Regensburg B3 1.388 Franz-Josef-Strauss-Allee 11 93053 Regensburg Tel.: +49-941-944-7230
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 ===