[sf-perl] [Fwd: class DBI postgres date time format]

Joe Brenner 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 mailing list