casting float8 type
Hello everyone,
I apologize if this seems elementary to you, but I just spent quite a
bit of time searching the archives and the documentation for a way to do
this. I may have been looking wrong, but I tried to look in all of the
"obvious" places. Anyway...
How would I go about converting a value of type 'float8' to a value of
type 'int'? It's probably not possible to do a straight conversion of a
float to an int, but is there a truncate, or a rounding function that I
could use? I couldn't find such a thing in my search.
Thanks in advance,
Bob
Bob Dusek <bobd@palaver.net> wrote:
How would I go about converting a value of type 'float8' to a value
of type 'int'? It's probably not possible to do a straight
conversion of a float to an int, but is there a truncate, or a
rounding function that I could use? I couldn't find such a thing in
my search.
in a table/class `tbl' with an float attribute `fl' of my 6.3.2 database,
the following works:
select cast(fl as int4) from tbl;
Hope it helps!
Ulf
--
======================================================================
%%%%% Ulf Mehlig <ulf.mehlig@uni-bremen.de>
%%%%!%%% Projekt "MADAM" <umehlig@uni-bremen.de>
%%%% %!% %%%% ----------------------------------------------------
---| %%% MADAM: MAngrove | Center for Tropical Marine
||--%!% Dynamics | Biology
|| And | Fahrenheitstrasse 1
_ /||\_/\_ Management |
/ / \ \ ~~~~~~~~~~~~~~~~~ | 28359 Bremen/Germany
~~~~~~~~~~~~~~~~~~~~
Thank you Ulf,
It works perfectly (so far :-)
Thanks a lot,
Bob
Ulf Mehlig wrote:
Show quoted text
Bob Dusek <bobd@palaver.net> wrote:
How would I go about converting a value of type 'float8' to a value
of type 'int'? It's probably not possible to do a straight
conversion of a float to an int, but is there a truncate, or a
rounding function that I could use? I couldn't find such a thing in
my search.in a table/class `tbl' with an float attribute `fl' of my 6.3.2 database,
the following works:select cast(fl as int4) from tbl;
Hope it helps!
Ulf
--
======================================================================
%%%%% Ulf Mehlig <ulf.mehlig@uni-bremen.de>
%%%%!%%% Projekt "MADAM" <umehlig@uni-bremen.de>
%%%% %!% %%%% ----------------------------------------------------
---| %%% MADAM: MAngrove | Center for Tropical Marine
||--%!% Dynamics | Biology
|| And | Fahrenheitstrasse 1
_ /||\_/\_ Management |
/ / \ \ ~~~~~~~~~~~~~~~~~ | 28359 Bremen/Germany
~~~~~~~~~~~~~~~~~~~~