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
add comment

1 Answer

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..

http://archives.postgresql.org/pgsql-bugs/2009-09/msg00171.php

share|improve this answer
    
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
add comment

Your Answer

 
discard

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.