From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Cc: | pgsql-general(at)postgresql(dot)org, pgsql-patches(at)postgresql(dot)org, "David D(dot) Kilzer" <ddkilzer(at)theracingworld(dot)com>, Hitesh Patel <hitesh(at)presys(dot)com>, Jose Soares <jose(at)sferacarta(dot)com> |
Subject: | Re: [PATCHES] [PATCH] Contrib C source for casting MONEY to INT[248] and FLOAT[48] |
Date: | 2001-06-20 00:00:51 |
Message-ID: | 200106200000.f5K00pw22163@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers pgsql-patches |
Tom outlined the problems with this patch. We want to remove Money and
have it be part of Numeric.
> Attached please find a patch to cast (convert) the MONEY type to any one
> of the following types:
>
> INT2, INT4, INT8, FLOAT4, FLOAT8
>
> The patch is against PostgreSQL v7.0.3 and creates files in a new
> directory named contrib/money/. I'm pretty sure it won't compile
> against v7.1, but it won't be too hard to fix. (I'll do this when I
> upgrade to v7.1 at work, which will hopefully happen sooner rather than
> later.)
>
> I wrote this because I needed to convert MONEY to a standard decimal
> value and didn't want to do it on the client in Perl, and I didn't want
> to use a plpgsql function that used string parsing. Both solutions were
> too inefficient for my needs.
>
> http://postgresql.bteg.net/mhonarc/pgsql-general/2000-01/msg00446.html
>
> I wouldn't have used the MONEY type in the first place if I had known it
> was deprecated, but I didn't see this notice in the v7.0.3 documentation
> two to three months ago when designing the database. Oh well, my loss
> is your gain. :^)
>
> I've attempted to set the Reply-To field to pgsql-hackers, but please
> copy me on any posts as well.
>
> Comments welcome!
>
> Dave
[ Attachment, skipping... ]
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | ÀîÁ¢Ð | 2001-06-20 01:20:36 | Re: Re: [PATCHES] [PATCH] Contrib C source for casting MONEY to INT[248] and FLOAT[48] |
Previous Message | Tom Lane | 2001-06-19 22:54:41 | Re: postgres.h missing? |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-06-20 00:26:10 | Re: PlPerl compile failure |
Previous Message | Hiroshi Inoue | 2001-06-19 23:16:26 | Re: Re: Primary Key |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-06-20 00:04:46 | Re: [PATCHES] Cygwin contrib patch |
Previous Message | Bruce Momjian | 2001-06-19 23:46:02 | Re: possible patch to increase number of hash overflow pages? |