| From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Strange interval arithmetic |
| Date: | 2005-11-27 15:15:04 |
| Message-ID: | 4389CD78.4060504@familyhealth.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2005-11-27 15:45:18 | Re: Strange interval arithmetic |
| Previous Message | Christopher Kings-Lynne | 2005-11-27 14:44:56 | [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] |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2005-11-27 15:45:18 | Re: Strange interval arithmetic |
| Previous Message | Volkan YAZICI | 2005-11-27 12:12:14 | Re: Case Conversion Fix for MB Chars |