Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question

1 Answer 1

up vote 2 down vote accepted

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


share|improve this answer
thank you Rohan –  DarkCoffee Dec 28 '12 at 8:59
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

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.