Re: DATE_PART('field', INTERVAL) not intuitive literal reading of interval

2018-06-19 Thread Bruce Momjian
On Tue, May 22, 2018 at 10:55:14AM +, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/10/static/functions-datetime.html > Description: > > the result of > t=# SELECT DATE_PART('month', '2018-05-31'::ti

Re: postgresql 11 release notes

2018-06-19 Thread Euler Taveira
Brad, your forgot to reply to pgsql-docs. 2018-06-19 20:21 GMT-03:00 Brad DeJong : > How about dropping the which clause entirely? I split this off as > release-11-newunit-v1.patch for further discussion. > Works for me. Could you append it to v2? >> >> -Exclude unlogged, tempora

Re: Changes in serial / sequence introduced in Postgresql 10

2018-06-19 Thread Michael Paquier
On Tue, Jun 19, 2018 at 02:49:08PM -0400, Bruce Momjian wrote: > I don't think we realize there was a behavioral change here. I think we > were just trying to fix the case where the sequence maximum didn't match > the serial maximum. I am not sure if it is worth documenting it at this > point tho

Re: Changes in serial / sequence introduced in Postgresql 10

2018-06-19 Thread Bruce Momjian
On Sat, May 19, 2018 at 12:05:26PM +0100, Pantelis Theodosiou wrote: > I guess no one noticed this (for almost a year!) but I keep wondering whether > it would be worth adding a note in the docs about the different behaviour or > perhaps it's a bug that should be addressed. > > Should I post it to

Re: postgresql 11 release notes

2018-06-19 Thread Euler Taveira
2018-06-15 7:58 GMT-03:00 Brad DeJong : > same patch but renamed to match the patch file naming convention > Comments above: -Previously super users were exclusively granted to access these +Previously, super-users were exclusively granted access to these function

Re: FX modifier

2018-06-19 Thread Euler Taveira
2018-06-14 17:16 GMT-03:00 PG Doc comments form : > The FX modifier is defined only as "fixed format global option"--what does > this mean? > The usage notes do not mention FX for TO_CHAR. Does it work with TO_CHAR? > This is not a bug. The documentation is clear. "to_timestamp and to_date skip mu

Re: json_to_record Example

2018-06-19 Thread Bruce Momjian
On Sat, Jun 2, 2018 at 03:23:32PM +0200, Yousof Shaladi wrote: > Hi, > > Form my side I definitely agree with what you say and added. I think the > example makes it more clear as we have an example table used. > > Nothing to add from my side here. Patch applied back through 9.4. Thanks. -

Misc typos in documentation

2018-06-19 Thread Liudmila Mantrova
Hi, Please consider these small patches that fix a couple of typos in documentation. I have split them in two just in case rn-typos.patch conflicts with any current work on release-11.sgml, which seems to be going on in more than one thread. I'll appreciate your feedback if it should have be