Re: [DOCS] to_char(): 'FM' also suppresses *trailing* zeroes

2017-09-04 Thread Erwin Brandstetter
On 3 September 2017 at 19:52, Erwin Brandstetter wrote: > I think the root of the confusion is that the FM does for date/time > formatting what the manual says (table 9-25): > > FM | prefix fill mode (suppress leading zeroes and padding blanks) | >> FMMonth >> > > t

Re: [DOCS] to_char(): 'FM' also suppresses *trailing* zeroes

2017-09-03 Thread Erwin Brandstetter
On 28 August 2017 at 22:37, Tom Lane wrote: > Erwin Brandstetter writes: > > In Table 9-27. "Template Pattern Modifiers for Numeric Formatting" it > says: > > FM | prefix fill mode (suppress leading zeroes and padding blanks) | > FM > > > In fact

Re: [DOCS] Failing example for to_number()

2017-09-03 Thread Erwin Brandstetter
On 28 August 2017 at 22:53, Tom Lane wrote: > Erwin Brandstetter writes: > > On 21 August 2017 at 16:30, David G. Johnston < > david.g.johns...@gmail.com> > > wrote: > >> On Mon, Aug 21, 2017 at 5:36 AM, Erwin Brandstetter > > >> wrote: > &

Re: [DOCS] Failing example for to_number()

2017-08-21 Thread Erwin Brandstetter
On 21 August 2017 at 16:30, David G. Johnston wrote: > On Mon, Aug 21, 2017 at 5:36 AM, Erwin Brandstetter > wrote: > >> The manual suggests here: >> >> https://www.postgresql.org/docs/current/static/functions-for >> matting.html#FUNCTIONS-FORMATTING-T

[DOCS] Failing example for to_number()

2017-08-21 Thread Erwin Brandstetter
a (',') does not happen to be the group separator and the dot ('.') is not the decimal point. The example is incorrectly assuming en_US locale. It must instead work locale-agnostic. Replace: to_number ('12,454.8-', '99G999D9S') with: to_number ('12,454.8-', '99,999.9S') Regards Erwin Brandstetter

[DOCS] to_char(): 'FM' also suppresses *trailing* zeroes

2017-08-17 Thread Erwin Brandstetter
x27; also suppresses *trailing* zeroes after the comma. To fix, this might be changed to: suppress insignificant zeroes and padding blanks Or: suppress padding zeroes and blanks Regards Erwin Brandstetter

[DOCS] Contradicting information on the "vacuum threshold"

2017-08-11 Thread Erwin Brandstetter
lly use >= instead of > ... and update the explanation for autovacuum accordingly. Same for autovacuum_vacuum_threshold. Regards Erwin Brandstetter

[DOCS] Contradicting information for DEFERRABLE constraints

2013-05-24 Thread Erwin Brandstetter
Hi! The manual states here: http://www.postgresql.org/docs/current/static/sql-createtable.html DEFERRABLE NOT DEFERRABLE This controls whether the constraint can be deferred. A constraint that is not deferrable will be checked immediately *after every command*. Checking of constraints

Re: [DOCS] Reference function arguments by name

2013-05-11 Thread Erwin Brandstetter
On 11.05.2013 10:13, Sian Mountbatten wrote: On 2013-05-09 21:46, Erwin Brandstetter wrote: Hi! The manual says here: http://www.postgresql.org/docs/current/interactive/sql-createfunction.html http://www.postgresql.org/docs/devel/static/sql-createfunction.html argname The name of an

[DOCS] Reference function arguments by name

2013-05-11 Thread Erwin Brandstetter
Hi! The manual says here: http://www.postgresql.org/docs/current/interactive/sql-createfunction.html http://www.postgresql.org/docs/devel/static/sql-createfunction.html argname The name of an argument. Some languages (currently only PL/pgSQL) let you use the name in the function body.

[DOCS] Code examples for 39.6.1. Returning From a Function

2013-04-07 Thread Erwin Brandstetter
Aloha! Repost, since the first attempt on 03.04.2013 14:31 was before I subsrcibed to pgsql-docs and doesn't seem to have arrived. As advised by Pavel here: http://stackoverflow.com/questions/15731247/postgresql-function-syntax-error/15731425#15731425 I am sending this as possible code example