Re: 42.6.8 trapping errors

On Saturday, November 14, 2020, Post Gresql wrote: > On 2020-11-15 04:39, David G. Johnston wrote: > > On Saturday, November 14, 2020, PG Doc comments form < > nore...@postgresql.org> wrote: > >> The following documentation comment has been logged on the website: >> >> Page: https://www.postgresq

Re: 42.6.8 trapping errors

On 2020-11-15 04:39, David G. Johnston wrote: On Saturday, November 14, 2020, PG Doc comments form mailto:nore...@postgresql.org>> wrote: The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/plpgsql-control-structures.html

Re: create table with a CTE

On 2020-11-15 04:55, David G. Johnston wrote: On Sat, Nov 14, 2020 at 6:21 AM PG Doc comments form mailto:nore...@postgresql.org>> wrote: The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/sql-createtableas.html Description:

Re: create table with a CTE

On Sat, Nov 14, 2020 at 6:21 AM PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/13/sql-createtableas.html > Description: > > Hi. > I think you should include an example on how to create a table from a quer

Re: 42.6.8 trapping errors

On Saturday, November 14, 2020, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/13/plpgsql-control-structures.html > Description: > > Hi > I think that section should have more examples with the most commo

Re: Partitioning docs (was Re: Range partitioning and overlap)

I wrote: > "David G. Johnston" writes: >> I am curious as to your thoughts on unique indexes and whether/how to >> better incorporate advice regarding the use of ON CONFLICT with >> partitioning [1] vis-a-vis the overview's claim of: >> "The partitioning substitutes for leading columns of indexes,

42.6.8 trapping errors

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/plpgsql-control-structures.html Description: Hi I think that section should have more examples with the most common errors, like for example no_data_found when doing a select.

create table with a CTE

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/sql-createtableas.html Description: Hi. I think you should include an example on how to create a table from a query that uses a CTE in the query.