X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 2D04E475EC9 for ; Wed, 26 Mar 2003 02:10:43 -0500 (EST) Received: from ara.zf.jcu.cz (ara.zf.jcu.cz [160.217.161.4]) by postgresql.org (Postfix) with ESMTP id 0977A474E44 for ; Wed, 26 Mar 2003 02:10:42 -0500 (EST) Received: from ara.zf.jcu.cz (localhost [127.0.0.1]) by ara.zf.jcu.cz (8.12.1/8.12.1/Debian -5) with ESMTP id h2Q7Adpp031817; Wed, 26 Mar 2003 08:10:40 +0100 Received: (from zakkr@localhost) by ara.zf.jcu.cz (8.12.1/8.12.1/Debian -5) id h2Q7AdCq031816; Wed, 26 Mar 2003 08:10:39 +0100 Date: Wed, 26 Mar 2003 08:10:39 +0100 From: Karel Zak To: Josh Berkus Cc: pgsql-sql@postgresql.org Subject: Re: Does anyone use TO_CHAR(INTERVAL)? Message-ID: <20030326071039.GB27912@zf.jcu.cz> References: <200303250931.27351.josh@agliodbs.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200303250931.27351.josh@agliodbs.com> User-Agent: Mutt/1.3.28i X-Spam-Status: No, hits=-34.8 required=5.0 tests=BAYES_10,EMAIL_ATTRIBUTION,IN_REP_TO,REFERENCES, REPLY_WITH_QUOTES,USER_AGENT_MUTT autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200303/572 X-Sequence-Number: 12610 On Tue, Mar 25, 2003 at 09:31:27AM -0800, Josh Berkus wrote: > Folks, > > We're discussing the behavior of the current "to_char(interval)" function on > HACKERS. Does anyone on this list use the current behavior? Please speak > up, as we're trying to figure out what backward compatibility needs to be > maintained. > > PLEASE NOTE: This is only to_char() for INTERVAL values, NOT for dates, > timestamp, or numeric! NOTE (I already said in hackers list): we can mark it as deprecated in 7.4 and remove it in 7.5. What thinks about it someone from core team? Karel -- Karel Zak http://home.zf.jcu.cz/~zakkr/