Postgres Pro
Downloads
Home   >   mailing lists

format integer - Mailing list pgsql-sql

From ml@ft-c.de
Subject format integer
Date
Msg-id f3f20234950352a5342a3f6d7fc96eca1f8ebba6.camel@ft-c.de
Whole thread Raw
Responses Re: format integer  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: format integer  (Torge Kummerow <tk@panaccess.com>)
List pgsql-sql
Tree view 
Hello, 

I need a integer format with different decimal places 
The integer should have 6 diggits. (or 7 or 8)

Example (6-diggits)
input       -> output
123456.789  -> 123456  
1234.56789  ->   1234.56
12.3456789  ->     12.3456

but when it is more then 10^6 then 
12345678.9  -> 12345678 
 
Is there a pg function for this task?

Franz

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Question about WITH ORDINALITY and unnest
Next
From: "David G. Johnston"
Date:
Subject: Re: format integer