Re: [PATCHES] Fixes for MONEY type using locale - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: [PATCHES] Fixes for MONEY type using locale
Date
Msg-id 20071126184239.55234be8@commandprompt.com
Whole thread Raw
In response to Re: [PATCHES] Fixes for MONEY type using locale  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [PATCHES] Fixes for MONEY type using locale
List pgsql-hackers
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Mon, 26 Nov 2007 21:19:48 -0500
Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Bruce Momjian <bruce@momjian.us> writes:
> > Added to TODO list:
> >         * Allow MONEY to be cast to/from other numeric data types
> 
> So in other words, that's been added to the TODO list *purely* on your
> own say-so, and not because any users asked for it or anyone else
> thinks it's a good idea.
> 

Well if we are going to continue to support money (which I am against)
we should support the casting to numeric as that is by far a more
common implementation of money and we will have mixed environments.

> Since MONEY really ought to be considered a tagged type, I'm not at
> all impressed with the idea that there should be default casts
> between it and plain numerics.  There's a fundamental semantic gap
> there.

Perhaps but the practical gap is much narrower.

Sincerely,

Joshua D. Drake

> 
>             regards, tom lane
> 
> ---------------------------(end of
> broadcast)--------------------------- TIP 2: Don't 'kill -9' the
> postmaster
> 


- -- 
     === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564   24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997  http://www.commandprompt.com/        UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHS4QhATb/zqfZUUQRAraiAJ9HLeqG7nRbblPvJhu/JQwhOrmzxQCgpWGE
1JShnZ4xwM1+lQzTKCkGVcw=
=sErU
-----END PGP SIGNATURE-----

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Table inheritance, unique constraints and foreign key problem
Next
From: Tom Lane
Date:
Subject: Re: [PATCHES] Fixes for MONEY type using locale