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 1038C8B9C44 for ; Tue, 1 Feb 2005 13:28:01 +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 73224-09 for ; Tue, 1 Feb 2005 13:27:53 +0000 (GMT) Received: from tomts36-srv.bellnexxia.net (tomts36-srv.bellnexxia.net [209.226.175.93]) by svr1.postgresql.org (Postfix) with ESMTP id 04BB78B9B27 for ; Tue, 1 Feb 2005 13:27:55 +0000 (GMT) Received: from acer.sympatico.ca ([65.95.162.23]) by tomts36-srv.bellnexxia.net (InterMail vM.5.01.06.10 201-253-122-130-110-20040306) with ESMTP id <20050201132755.HOHM1694.tomts36-srv.bellnexxia.net@acer.sympatico.ca> for ; Tue, 1 Feb 2005 08:27:55 -0500 Message-Id: <5.2.1.1.0.20050201081957.00a06d80@pop6.sympatico.ca> X-Sender: b1wudu74@pop6.sympatico.ca X-Mailer: QUALCOMM Windows Eudora Version 5.2.1 Date: Tue, 01 Feb 2005 08:24:50 -0500 To: pgsql-php@postgresql.org From: Frank Bax Subject: Re: to_char replacement In-Reply-To: <20050124174435.GC86325@winnie.fuhr.org> References: <001401c50234$66a0b410$0a10a8c0@zerosoft.ro> <001401c50234$66a0b410$0a10a8c0@zerosoft.ro> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.036 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200502/3 X-Sequence-Number: 2977 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.