Ron Mayer <rm_pg@xxxxxxxxxxxxxxxxxxxxxxx> writes: > Looks like the original questions from the thread > got resolved, but I found this behaviour surprising: > regression=# select interval '1' day to second; > interval > ---------- > @ 1 hour > (1 row) > Should this be 1 second? That is a bit odd, especially seeing that eg. '1' hour to second comes out as 1 second. What's making it do that? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general