Received: from frithjof.reiner (c113.dialin.tuwien.ac.at [192.35.243.123]) by postgresql.org (8.11.3/8.11.1) with SMTP id f43GpHA09475 for ; Thu, 3 May 2001 12:51:17 -0400 (EDT) (envelope-from areiner@tph.tuwien.ac.at) Received: (qmail 1065 invoked by uid 500); 1 May 2001 12:36:43 -0000 From: "Albert REINER" Date: Tue, 1 May 2001 14:36:43 +0200 To: PostgreSQL-SQL Subject: '13 months ago'::reltime Message-ID: <20010501143643.A929@frithjof> Mail-Followup-To: PostgreSQL-SQL Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i X-Archive-Number: 200105/11 X-Sequence-Number: 2809 Saluton, I do not quite understand the following: ,---- | albert=> select '13 months ago'::reltime; | ?column? | --------------------- | 1 year 25 00:00 ago | (1 row) | | albert=> select '13 months ago'::interval; | ?column? | ------------------------ | 1 year 1 mon 00:00 ago | (1 row) | | albert=> select version(); | version | -------------------------------------------------------------------- | PostgreSQL 7.0.2 on i586-pc-linux-gnulibc1, compiled by gcc 2.95.1 | (1 row) `---- Shouldn't 13 months be 1 year and 1 month even for reltime? Somewhat puzzled, Albert.