Tom you are correct here (like usual), sorry for the wasted thread and time regarding functions that I remembered being there but infact were not.
On Wednesday 29 January 2003 10:56, Tom Lane wrote: > Darcy Buskermolen <[EMAIL PROTECTED]> 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster -- Darcy Buskermolen Wavefire Technologies Corp. ph: 250.717.0200 fx: 250.763.1759 http://www.wavefire.com ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
