From: | "Morris, Roy" <rmorris(at)internetsecure(dot)com> |
---|---|
To: | "Ennio-Sr" <nasr(dot)laili(at)tin(dot)it>, <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: How to transform pg_7.4 function 'to_number' to 8.4 equivalent? |
Date: | 2008-10-17 18:26:02 |
Message-ID: | 19BA112CA339EB47B0E90EBAE50D132D03542FFC@exch1.internal.priv |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I could be wrong (likely) but I just changed the format template to use '9999D0000' and it works fine.
-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org]On Behalf Of Ennio-Sr
Sent: Friday, October 17, 2008 1:56 PM
To: pgsql-novice(at)postgresql(dot)org
Subject: [NOVICE] How to transform pg_7.4 function 'to_number' to 8.4
equivalent?
Hi all,
after upgrading from pg_7.4 to pg_8.3 when I run this command:
psql finanza -c "SELECT titolo, var, pr_chius, pr_aper, \
diff_aper_ch*(-1) as \"diff. ass.\", \
to_number(diff_aper_ch*(-1)/pr_aper*100::float(8),'9999.000000') as \"sc. %\" \
from ult_qq having pr_chius>pr_aper and pr_aper>0 \
order by titolo;" | tee -a /home/ennio/.tmp/aaa
I get:
ERROR: function to_number(double precision, unknown) does not exist ...
Of course it worked very well under 7.4 ...
Can somebody suggest how to correct this?
Regards,
Ennio
--
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo. \\?//
Fa' qualche cosa di cui non sei capace!" (diceva Henry Miller) ] (°|°)
Ricevo solo messaggi Content-Type: plain/text (no html o multipart). )=(
!!! --> e-mail a mio nome via OE (M$) sono false e infette <-- !!!
From | Date | Subject | |
---|---|---|---|
Next Message | Isabella Ghiurea | 2008-10-17 18:30:26 | how to see all tables/object in db |
Previous Message | Ennio-Sr | 2008-10-17 17:56:14 | How to transform pg_7.4 function 'to_number' to 8.4 equivalent? |