Re: BUG #6096: ECPG set precision of double value to 14 digits

Hi,

I built PostgreSQL 8.4.8 with the following patch,
then executed same program.

This result is same as psql's one.

--------------------------------------------------
testdb=# SELECT * FROM double_table;
        c1
-------------------
    12345678901234
   1234567890.1234
  0.12345678901234
   123456789012345
  1234567890.12345
 0.123456789012345
(6 rows)
--------------------------------------------------


*** execute.c.org       2011-04-15 12:17:14.000000000 +0900
--- execute.c   2011-07-16 19:46:05.000000000 +0900
***************
*** 709,720 ****
                                        strcpy(mallocedval, "array [");

                                        for (element = 0; element < asize; element++)
!                                               sprintf(mallocedval + strlen(mallocedval), "%.14g,", ((double *)
var->value)[element]);

                                        strcpy(mallocedval + strlen(mallocedval) - 1, "]");
                                }
                                else
!                                       sprintf(mallocedval, "%.14g", *((double *) var->value));

                                *tobeinserted_p = mallocedval;
                                break;
--- 709,720 ----
                                        strcpy(mallocedval, "array [");

                                        for (element = 0; element < asize; element++)
!                                               sprintf(mallocedval + strlen(mallocedval), "%.15g,", ((double *)
var->value)[element]);

                                        strcpy(mallocedval + strlen(mallocedval) - 1, "]");
                                }
                                else
!                                       sprintf(mallocedval, "%.15g", *((double *) var->value));

                                *tobeinserted_p = mallocedval;
                                break;