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 ===