Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154] (may be forged)) by hub.org (8.10.1/8.10.1) with ESMTP id e8NGlcs92271 for ; Sat, 23 Sep 2000 12:47:38 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.0/8.11.0) with ESMTP id e8NGkIB01826; Sat, 23 Sep 2000 12:46:18 -0400 (EDT) To: ldm@apartia.ch cc: Thomas Lockhart , pgsql-sql@postgresql.org Subject: Re: missing "day(s)" in interval (was: Convert from Seconds-Since-Epoch to Timestamp) In-reply-to: <20000923174520.A10680@styx> References: <20000921181036.3514.qmail@web805.mail.yahoo.com> <5.0.0.19.2.20000921145244.02438d00@pop> <39CA6EA1.5610BD7@ipinc.com> <20000923174520.A10680@styx> Comments: In-reply-to Louis-David Mitterrand message dated "Sat, 23 Sep 2000 17:45:20 +0200" Date: Sat, 23 Sep 2000 12:46:18 -0400 Message-ID: <1823.969727578@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200009/192 Louis-David Mitterrand writes: > By the way, is it normal that the "day" word doesn't appear in the interval? > auction=# select interval(now()::abstime::int4); > interval > ---------------------------- > 30 years 9 mons 3 15:42:09 > (1 row) Looks like a bug to me ... Thomas, do you agree? Curiously, it appears that the interval input converter will accept this with or without the 'days' keyword included. regards, tom lane