X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 682098B9E1A for ; Wed, 2 Feb 2005 18:15:53 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 30641-05 for ; Wed, 2 Feb 2005 18:15:50 +0000 (GMT) Received: from candle.pha.pa.us (candle.pha.pa.us [207.106.42.251]) by svr1.postgresql.org (Postfix) with ESMTP id 2D5528B9E03 for ; Wed, 2 Feb 2005 18:15:47 +0000 (GMT) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.11.6) id j12IFcI01979; Wed, 2 Feb 2005 13:15:38 -0500 (EST) From: Bruce Momjian Message-Id: <200502021815.j12IFcI01979@candle.pha.pa.us> Subject: Re: to_char replacement In-Reply-To: <5.2.1.1.0.20050201081957.00a06d80@pop6.sympatico.ca> To: Frank Bax Date: Wed, 2 Feb 2005 13:15:38 -0500 (EST) Cc: pgsql-php@postgresql.org X-Mailer: ELM [version 2.4ME+ PL121 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/6 X-Sequence-Number: 2980 Frank Bax wrote: > At 12:44 PM 1/24/05, Michael Fuhr wrote: > > >On Mon, Jan 24, 2005 at 06:47:33PM +0200, Raul Secan wrote: > > > > > Hello, since to_char() function will no longer be available from > > > PostgreSQL 8.1 ... I might need to change that from my scripts. > > > >Eh? Where did you get the idea that to_char() was going away? The > >documentation says that to_char(interval, text) is deprecated and > >will be removed, but it says nothing about removing the function > >altogether. > > > Raul is not the only one who misread that sentence. I thought the same > thing when I read it last week. Reading too quickly, I guess. After > spending several minutes searching for a replacement function, I went back > a reread it, understanding it the second time. Perhaps if > to_char(interval, text) were marked with (*) in table and then (*) note at > bottom, it would be clearer that this sentence does not apply to all arguments. Agreed. I think we were a little too concise in that statement. Here is the updated wording: The 8.1 release will remove the to_char() function for intervals. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073