Re: question about default value and timestamp

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