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.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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: I think 8.5 might be a dev version (here is the relevant commit for this change, I am not too sure about the versioning though.. – WrinkleFree 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.