Skip site navigation (1) Skip section navigation (2)

Re: [TEST REPORT] 9.1Alpha3 Feature E.1.4.7.2 in release notes.

From: Itagaki Takahiro <itagaki(dot)takahiro(at)gmail(dot)com>
To: Ramanujam <innomotive(at)gmail(dot)com>
Cc: pgsql-testers(at)postgresql(dot)org
Subject: Re: [TEST REPORT] 9.1Alpha3 Feature E.1.4.7.2 in release notes.
Date: 2011-01-07 07:34:33
Message-ID: AANLkTi=ZtTxhUdBZKqPMZdnZPt3AGVmtW9+iAdAXgtuJ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-testers
On Fri, Jan 7, 2011 at 15:54, Ramanujam <innomotive(at)gmail(dot)com> wrote:
> [Release]: 9.1Alpha3. Binaries compiled with mingw-32 (gcc 4.4.0) on
> i686 without zlib support.

> [Test]: a) Check feature E.1.4.7.2 in 9.1Alpha3 release notes
> (Monetary data type). b) Documentation mistake(?)
>
> [Results]: Documentation states that integer literals are allowed
> values for input. I am getting the following error:

The docs is:
http://developer.postgresql.org/pgdocs/postgres/datatype-money.html
| Input is accepted in a variety of formats,
| including integer and floating-point literals

The reported issue doesn't depend on lc_monetary.
It comes from missing cast support from integer to money.

Should we have cast to/from integer to numeric?  It is inconsistent
that 1::numeric::money is accepted but 1::money is not.


postgres=# SHOW lc_monetary;
 lc_monetary
-------------
 C
(1 row)

postgres=# SELECT 1::numeric::money;
 money
-------
 $1.00
(1 row)

postgres=# SELECT 1::integer::money;
ERROR:  cannot cast type integer to money
LINE 1: SELECT 1::integer::money;
                         ^
postgres=# SELECT castsource::regtype, casttarget::regtype,
castfunc::regproc, castcontext FROM pg_cast WHERE casttarget =
'money'::regtype;
 castsource | casttarget | castfunc | castcontext
------------+------------+----------+-------------
 numeric    | money      | money    | a
(1 row)

postgres=# \df money
                          List of functions
   Schema   | Name  | Result data type | Argument data types |  Type
------------+-------+------------------+---------------------+--------
 pg_catalog | money | money            | numeric             | normal
(1 row)


-- 
Itagaki Takahiro

In response to

Responses

pgsql-hackers by date

Next:From: Florian WeimerDate: 2011-01-07 08:21:41
Subject: Re: WIP: Range Types
Previous:From: RamanujamDate: 2011-01-07 06:54:54
Subject: [TEST REPORT] 9.1Alpha3 Feature E.1.4.7.2 in release notes.

pgsql-testers by date

Next:From: Itagaki TakahiroDate: 2011-01-11 01:48:42
Subject: Fwd: [TESTERS] [TEST REPORT] 9.1Alpha3 Feature E.1.4.7.2 in release notes.
Previous:From: RamanujamDate: 2011-01-07 06:54:54
Subject: [TEST REPORT] 9.1Alpha3 Feature E.1.4.7.2 in release notes.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group