Home > mailing lists

How to truncate? integers - Mailing list pgsql-novice

From	Johann Schatzer
Subject	How to truncate? integers
Date	November 16, 2011 16:32:39
Msg-id	CAGa0SzeEjfbspjLCb=Sn05PGD4c+iLrQ4o_+Cps=ZrYaY87eeg@mail.gmail.com Whole thread Raw
Responses	Re: How to truncate? integers Re: How to truncate? integers Re: How to truncate? integers Re: How to truncate? integers Re: How to truncate? integers
List	pgsql-novice

Tree view

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

pgsql-novice by date:

From: Baux David
Date: 16 November 2011, 05:04:58
Subject: Re:

From: J. Pablo González
Date: 16 November 2011, 16:33:36
Subject: ecpg - char as host var

How to truncate? integers - Mailing list pgsql-novice

Previous

Next