patternsqlMinor
SET extra_float_digits = 3
Viewed 0 times
extra_float_digitssetstackoverflow
Problem
I'm using PostgreSQL 9.2 with my web application that has three servlets with three selects.
I turn on the log.
When I send my first query:
before it the log shows me this other line:
What is this command?
I turn on the log.
When I send my first query:
select * from "Nomi" limit 4before it the log shows me this other line:
execute : SET extra_float_digits = 3What is this command?
Solution
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
http://archives.postgresql.org/pgsql-bugs/2009-09/msg00171.php
Context
StackExchange Database Administrators Q#31108, answer score: 2
Revisions (0)
No revisions yet.