Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id A3CCB1337BA0 for ; Tue, 11 Jan 2011 08:26:58 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 75354-01 for ; Tue, 11 Jan 2011 12:26:51 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail.gmx.net (mailout-de.gmx.net [213.165.64.23]) by mail.postgresql.org (Postfix) with SMTP id D68E11337B93 for ; Tue, 11 Jan 2011 08:26:50 -0400 (AST) Received: (qmail invoked by alias); 11 Jan 2011 12:26:50 -0000 Received: from fsgw.f-secure.com (EHLO [10.128.133.18]) [193.110.108.33] by mail.gmx.net (mp067) with SMTP; 11 Jan 2011 13:26:50 +0100 X-Authenticated: #495269 X-Provags-ID: V01U2FsdGVkX1/tmqF+cZ3tHi0nO+VnBAdqD9F3TZ//lUzSkQlDsG oJlgosoD9NZ2nb Subject: Re: Fwd: [TESTERS] [TEST REPORT] 9.1Alpha3 Feature E.1.4.7.2 in release notes. From: Peter Eisentraut To: Itagaki Takahiro Cc: Tom Lane , PostgreSQL Hackers In-Reply-To: References: <4741.1294711809@sss.pgh.pa.us> Content-Type: text/plain; charset="UTF-8" Date: Tue, 11 Jan 2011 14:26:48 +0200 Message-ID: <1294748808.15734.0.camel@fsopti579.F-Secure.com> Mime-Version: 1.0 X-Mailer: Evolution 2.30.3 Content-Transfer-Encoding: 7bit X-Y-GMX-Trusted: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.909 tagged_above=-5 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201101/702 X-Sequence-Number: 178539 On tis, 2011-01-11 at 12:30 +0900, Itagaki Takahiro wrote: > On Tue, Jan 11, 2011 at 11:10, Tom Lane wrote: > > Itagaki Takahiro writes: > >> It was reported from a tester that we don't have casts of money from/to integer > >> types even though we have from/to numeric type. > > > > In most locales, the idea isn't sensible. > > The documentation says: > | Input is accepted in a variety of formats, > | including integer and floating-point literals > > If we won't to add accept integers for money, we should fix the docs. > | integer and floating-point string literals > | ~~~~~~~~~~~~~~~ > Will it get better? I think adding a cast from integer to money is probably quite reasonable. The other way around, maybe not, or only an explicit cast.