On Monday, January 21, 2013 at 18:11, bgd39h5xxt@xxxxxxxxxxxxxx
(Nathan Clayton nathanclayton-at-gmail.com |pg-gts/Basic|) wrote:
I only wish. I work with a transactional system from the 70s on
a daily basis that decided to store something like a "work date" and
"work time". The date changes whenever they decide to dateroll the
system. Until then the time field continues to grow, so you see times
like 25:00 and 26:00 all the time.
SELECT execute(relevant_dba) FROM the_70s WITH tardis WHERE
working_tardis = true;
Exceptions abound.
At least that can't be blamed on a government, and, we can only
hope ISO-8601 will prevent more examples being created.
You sound as though you really need, and/or already have, a
dedicated datatype... if only to stop 'the system' from 'fixing'
such weirdness.
Regards
Gavan Schneider
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
