diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2017-08-29 09:34:21 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2017-08-29 09:34:21 -0400 |
| commit | 5c81c881f7caceffb9dd3174a72a724db04d073f (patch) | |
| tree | d72e22f7d98c7ff0e6dfa526e1e84291a3ac5fd1 /src/interfaces/libpq/fe-exec.c | |
| parent | 8c894c5ff58ff41b59f1ba5c9d487aa9c3073a2f (diff) | |
Improve docs about numeric formatting patterns (to_char/to_number).
The explanation about "0" versus "9" format characters was confusing
and arguably wrong; the discussion of sign handling wasn't very good
either. Notably, while it's accurate to say that "FM" strips leading
zeroes in date/time values, what it really does with numeric values
is to strip *trailing* zeroes, and then only if you wrote "9" rather
than "0". Per gripes from Erwin Brandstetter.
Discussion: https://postgr.es/m/CAGHENJ7jgRbTn6nf48xNZ=FHgL2WQ4X8mYsUAU57f-vq8PubEw@mail.gmail.com
Discussion: https://postgr.es/m/CAGHENJ45ymd=GOCu1vwV9u7GmCR80_5tW0fP9C_gJKbruGMHvQ@mail.gmail.com
Diffstat (limited to 'src/interfaces/libpq/fe-exec.c')
0 files changed, 0 insertions, 0 deletions