Re: An XSLT example script

2020-04-20 Thread Bruce Momjian
On Tue, Apr 14, 2020 at 10:03:53AM +0200, Jürgen Purtz wrote: > The example "XSLT Stylesheet for Converting SQL/XML Output to HTML" is > tagged as , but it isn't a figure, it's an example script. The PDF > output contains lists for examples, figures and tables and shows it in the > wrong list. We

Re: pgsql: doc: add examples of creative use of unique expression indexes

2020-04-20 Thread Bruce Momjian
On Mon, Apr 20, 2020 at 04:21:32PM -0400, Tom Lane wrote: > [ sorry, I'd lost track of this thread ] > > Bruce Momjian writes: > > I now remember that I wrote the first IS NULL in: > > CREATE UNIQUE INDEX tests_target_one_null ON tests ((target IS NULL)) > > WHERE target IS NULL; > > in hope

Re: pgsql: doc: add examples of creative use of unique expression indexes

2020-04-20 Thread Tom Lane
[ sorry, I'd lost track of this thread ] Bruce Momjian writes: > I now remember that I wrote the first IS NULL in: > CREATE UNIQUE INDEX tests_target_one_null ON tests ((target IS NULL)) WHERE > target IS NULL; > in hope that if someone is looking for the null value in the column, the > IS

prefix match operator ^@

2020-04-20 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/functions-string.html Description: Preparing to upgrade old PostgreSQL and looking changelog, I has found log about "prefix text match" operator (boosted by SP_GIST): => select 'ab' ^@

Re: Documentation issue: Default value of temp_buffers

2020-04-20 Thread Alvaro Herrera
Hello, On 2020-Apr-20, PG Doc comments form wrote: > https://www.postgresql.org/docs/11/runtime-config-resource.html says: > > --snip-- > temp_buffers (integer): > Sets the maximum number of temporary buffers used by each database session > [...] The default is eight megabytes (8MB). >

Documentation issue: Default value of temp_buffers

2020-04-20 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/runtime-config-resource.html Description: https://www.postgresql.org/docs/11/runtime-config-resource.html says: --snip-- temp_buffers (integer): Sets the maximum number of

Re: Additional Chapter for Tutorial

2020-04-20 Thread Jürgen Purtz
On 17.04.20 20:40, Erik Rijkers wrote: Very good stuff, and useful. I think. I mean that but nevertheless here is a lot of comment :) (I didn't fully compile as docs, just read the 'text' from the patch file) Thanks. Added nearly all of the suggestions. -- Jürgen Purtz diff --git