SET extra_float_digits = 3

Question

I'm using postgresql 9.2 with my web application that has three servlet with three select.

I turn on the log.

When i send my first query: 'select * from "Nomi" limit 4'

before this the log show me this other line:

'execute : SET extra_float_digits = 3'

What is this command?

Rohan · Accepted Answer · 2012-12-28 08:36:04Z

up vote 1 down vote accepted

Looks like that is a default setting in postgresql 8.5 onwards to guarantee recovery of higher precisions floats..

answered Dec 28 '12 at 8:36

Rohan
615218

thank you Rohan – DarkCoffee Dec 28 '12 at 8:59

3

Version 8.5 doesn't exist, it's 9.0 – Frank Heikens Dec 28 '12 at 9:33

@Frank: postgresql.org/about/news/1152 I think 8.5 might be a dev version (here is the relevant commit for this change archives.postgresql.org/pgsql-bugs/2009-09/msg00180.php), I am not too sure about the versioning though.. – Rohan Dec 28 '12 at 11:02

1 Answer