Float values to String in Postgresql

Question

I'm using PgSQL 9.1.

SELECT 5.1::text

is working fine with output '5.1' in PgAdmin3, but with JDBC Prepared statement EXEC SQL, the result always as '5.0999999'.

Of source SELECT to_char(5.1, '9.9') will work, however this is not what I want. I want to get '5' in the case of 5.0 without decimal point, so I just stay on the ::text conversion.

My assumption is there might be some session environment settings affected to this conversion somewhere, but I can't figure out how to find.

I know this is just a silly question... please help.

tsohr · Accepted Answer · 2015-02-17 03:32:19Z

9

I think I found a solution. Try to cast into numeric type first...

SELECT (5.1::numeric)::text

Please add your answer if you have a better solution.

answered Feb 17, 2015 at 3:32

tsohr

9152 gold badges15 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Walker Farrow · Accepted Answer · 2015-02-17 15:23:19Z

2

Do the following:

select cast(5.1 as text)

answered Feb 17, 2015 at 15:23

Walker Farrow

4,0269 gold badges36 silver badges58 bronze badges

Comments

FlameStorm · Accepted Answer · 2024-03-14 09:55:09Z

1

In 2024 for Postgres 13.2 it works best as

SELECT (5.1::real)::text

For example, let's take an field test numeric(32,4) not null default 0. Then:

SELECT t.test FROM test_table t
-- 5.1000
SELECT t.test::text FROM test_table t
-- 5.1000
SELECT t.test::numeric::text FROM test_table t
-- 5.1000
SELECT t.test::real::text FROM test_table t
-- 5.1

answered Mar 14, 2024 at 9:55

FlameStorm

1,0322 gold badges17 silver badges20 bronze badges

Collectives™ on Stack Overflow

Float values to String in Postgresql

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related