X-Original-To: pgsql-sql@postgresql.org
Received: from serwer.skawsoft.com.pl (serwer.skawsoft.com.pl [213.25.37.66])
	by postgresql.org (Postfix) with ESMTP id 55183475E82
	for <pgsql-sql@postgresql.org>; Mon, 17 Mar 2003 09:14:17 -0500 (EST)
Received: from klaster.net (pa34.krakow.cvx.ppp.tpnet.pl [213.76.36.34])
	by serwer.skawsoft.com.pl (Postfix) with ESMTP
	id 26A796A1E6; Mon, 17 Mar 2003 15:14:19 +0100 (CET)
Message-ID: <3E75D87A.7020908@klaster.net>
Date: Mon, 17 Mar 2003 15:15:22 +0100
From: Tomasz Myrta <jasiek@klaster.net>
User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; pl-PL;
 rv:1.3) Gecko/20030312
X-Accept-Language: pl, en-us, en
MIME-Version: 1.0
To: Christoph Haller <ch@rodos.fzk.de>
Cc: mallah@trade-india.com, pgsql-sql@postgresql.org
Subject: Re: Formatting intervals..
References: <3E75C7BE.5BFE8C6C@rodos.fzk.de>
In-Reply-To: <3E75C7BE.5BFE8C6C@rodos.fzk.de>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200303/395
X-Sequence-Number: 12434

>>It doesn't make sense. You don't have whole date, so how long should
>>month be? 28? 29? 30? 31?
>>
> 
> It does. As long the months between January and October are.
> So
> select age ('10-10-1999'::timestamp , '1-1-1999'::timestamp ) ;
>       age
> ---------------
>  9 mons 9 days
> (1 row)
> 
> Regards, Christoph
Your example above is related to some real date, so we know how many 
days each month have. When using interval - we don't know how many days 
each month should have. beacuse interval is unrelated to date.

Tomasz