Postgres Pro
Downloads
Home   >   mailing lists

Re: How to truncate? integers - Mailing list pgsql-novice

From Leif Biberg Kristensen
Subject Re: How to truncate? integers
Date
Msg-id 201111162230.11062.leif@solumslekt.org
Whole thread Raw
In response to How to truncate? integers  (Johann Schatzer <schatzer.johann@gmail.com>)
List pgsql-novice
Tree view 
On Wednesday 16. November 2011 21.26.19 Johann Schatzer wrote:
> How can I ~truncate~ integers?
>
>
> this column
>
> 4770
> 4780
> 4800
> 4810
> 4840
> 4900
> 4930
> 4950
> 4960
> 5070
> 5090
> 5130
>
> should give
>
> 4700
> 4700
> 4800
> 4800
> 4800
> 4900
> 4900
> 4900
> 4900
> 5000
> 5000
> 5100
>
> thank you

Divide by 100, keep integer part, and multiply again by 100:

test=> select (4770/100)::integer * 100;
 ?column?
----------
     4700
(1 row)

Time: 0,426 ms
test=>

regards,
Leif

pgsql-novice by date:

Previous
From: Richard Broersma
Date:
Subject: Re: How to truncate? integers
Next
From: "Jean-Yves F. Barbier"
Date:
Subject: Re: How to truncate? integers