Re: [GENERAL] casting float8 type - Mailing list pgsql-general

From Bob Dusek
Subject Re: [GENERAL] casting float8 type
Date
Msg-id 36419469.9343F24F@palaver.net
Whole thread Raw
In response to casting float8 type  (Bob Dusek <bobd@palaver.net>)
List pgsql-general
Thank you Ulf,

It works perfectly (so far :-)

Thanks a lot,

Bob

Ulf Mehlig wrote:
>
> 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
>   ~~~~~~~~~~~~~~~~~~~~

pgsql-general by date:

Previous
From: Bob Dusek
Date:
Subject: age('now',date::datetime)
Next
From: Memphisto
Date:
Subject: insert problem.