[sf-perl] [Fwd: class DBI postgres date time format]
doom at kzsu.stanford.edu
Thu Mar 19 11:29:54 PDT 2009
Kevin Frost <biztos at mac.com> wrote:
> Also, I would argue that in Fred's example the modified timestamp
> ("mts") should not have a default value. When you create a
> record but do not subsequently modify it, its modification
> timestamp should be NULL, so you can tell the difference. This
> of course is highly impractical because you then have to remember
> about the NULLs in all your queries for the rest of your life, so
> it's an argument I often lose.
I'm not sure I get the logic in any case. Creation strikes me as a
kind of modification.
More information about the SanFrancisco-pm