Postgres Pro
Downloads
Home   >   mailing lists

Strange interval arithmetic - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Strange interval arithmetic
Date
Msg-id 4389CD78.4060504@familyhealth.com.au
Whole thread Raw
Responses Re: Strange interval arithmetic  (Michael Fuhr <mike@fuhr.org>)
List pgsql-hackers
Tree view 
What's going on here?  Some sort of integer wraparound?

WORKS
=====

mysql=# select interval '2378 seconds'; interval
---------- 00:39:38
(1 row)

mysql=#
mysql=# select 2378 * interval '1 second'; ?column?
---------- 00:39:38
(1 row)

DOESN'T WORK
============

test=# select interval '2378234234 seconds';   interval
-------------- 596523:14:07
(1 row)

test=# select 2378234234 * interval '1 second';   ?column?
-------------- 660620:37:14
(1 row)

pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: [Fwd: [PHP-CVS] cvs: php-src(PHP_5_1) /ext/pdo_pgsql package.xml pgsql_driver.c pgsql_statement.c php_pdo_pgsql_int.h]
Next
From: Michael Fuhr
Date:
Subject: Re: Strange interval arithmetic