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

Re: No migration path for MONEY

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Darcy Buskermolen <darcy(at)wavefire(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: No migration path for MONEY
Date: 2003-01-29 18:56:50
Message-ID: 28245.1043866610@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Darcy Buskermolen <darcy(at)wavefire(dot)com> writes:
> Sorry my mistake on versions.
> darcy=> SELECT '1.0'::MONEY::FLOAT;
> ?column?
> --------
>        1
> (1 row)
> darcy=> select version();
> version                                                             
> --------------------------------------------------------------------
> PostgreSQL 6.5.2 on i386-unknown-freebsd3.2, compiled by gcc 2.7.2.1
> (1 row)

I don't have a 6.5 system around to test anymore, but my recollection is
that back then, constructs like 'literal'::foo::bar were collapsed into
'literal'::bar --- so the above doesn't prove 6.5 could actually convert
money into float.  What happens if you take a money column and try to
coerce it, ie "SELECT moneycol::float FROM mytable" ?

			regards, tom lane

In response to

Responses

pgsql-bugs by date

Next:From: Darcy BuskermolenDate: 2003-01-29 19:12:00
Subject: Re: No migration path for MONEY
Previous:From: Darcy BuskermolenDate: 2003-01-29 17:57:42
Subject: Re: No migration path for MONEY

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