Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Strange interval arithmetic
- 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: Sun, 27 Nov 2005 23:15:04 +0800
- Message-id: <4389CD78(dot)4060504(at)familyhealth(dot)com(dot)au>
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)
- Follow-Ups:
- Re: Strange interval arithmetic
- From: Michael Fuhr
- Re: Strange interval arithmetic
- Prev by Date: [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 by Date: Re: Strange interval arithmetic
- Previous by thread: [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 by thread: Re: Strange interval arithmetic
- Indexes: