Re: INSERT RETURNING

On Sun, Aug 28, 2022 at 7:51 AM PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/14/dml-returning.html > Description: > > If I execute the below query > ``` > CREATE TABLE users ( > id serial primary key,

Re: Does postgres have Equivalent range C range Ty​pe for Built-in SQL range Types

ne 28. 8. 2022 v 18:36 odesílatel jian he napsal: > > > On Sun, Aug 28, 2022 at 4:07 PM Pavel Stehule > wrote: > >> >> >> ne 28. 8. 2022 v 12:36 odesílatel Pavel Stehule >> napsal: >> >>> Hi >>> >>> >>> ne 28. 8. 2022 v 10:10 odesílatel jian he >>> napsal: >>> Equivalent C Types for

Re: Does postgres have Equivalent range C range Ty​pe for Built-in SQL range Types

On Sun, Aug 28, 2022 at 4:07 PM Pavel Stehule wrote: > > > ne 28. 8. 2022 v 12:36 odesílatel Pavel Stehule > napsal: > >> Hi >> >> >> ne 28. 8. 2022 v 10:10 odesílatel jian he >> napsal: >> >>> >>> Equivalent C Types for Built-in SQL Types >>> https://www.postgresql.org/docs/15/xfunc-c.html#XFU

Re: Section 40.1 Overview of Event Trigger Behavior, and Table 40.1 missing needed details

On 2022-Aug-27, PG Doc comments form wrote: > Section 40.1. Overview of Event Trigger Behavior says: > "The table_rewrite event occurs just before a table is rewritten by some > actions of the commands ALTER TABLE and ALTER TYPE." > Issue: Neither the section nor the table describe which actions o

INSERT RETURNING

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/dml-returning.html Description: If I execute the below query ``` CREATE TABLE users ( id serial primary key, name varchar(255) ) INSERT INTO users (name) VALUES ('a'), ('b'), ('c') RET

Section 40.1 Overview of Event Trigger Behavior, and Table 40.1 missing needed details

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/event-trigger-matrix.html Description: RE: https://www.postgresql.org/docs/current/event-trigger-matrix.html Section 40.1. Overview of Event Trigger Behavior says: "The table_rewrite even

Re: Handling of quantity in recursive query example

Simon Riggs writes: > On Sat, 27 Aug 2022 at 18:04, PG Doc comments form > wrote: >> As currently written, if a car has four wheels, and each wheel has five >> bolts, the whole example returns five bolts for the parts of a car. With the >> proposed change, it will return 20 bolts. > I agree, bas

Re: Handling of quantity in recursive query example

On Sat, 27 Aug 2022 at 18:04, PG Doc comments form wrote: > > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/14/queries-with.html > Description: > > I believe that the second query in section 7.8.2 (Recursive Queries) should > be modif

Re: Does postgres have Equivalent range C range Ty​pe for Built-in SQL range Types

ne 28. 8. 2022 v 12:36 odesílatel Pavel Stehule napsal: > Hi > > > ne 28. 8. 2022 v 10:10 odesílatel jian he > napsal: > >> >> Equivalent C Types for Built-in SQL Types >> https://www.postgresql.org/docs/15/xfunc-c.html#XFUNC-C-TYPE-TABLE >> Does postgres have Equivalent C range Type for Built-

Re: Does postgres have Equivalent range C range Ty​pe for Built-in SQL range Types

Hi ne 28. 8. 2022 v 10:10 odesílatel jian he napsal: > > Equivalent C Types for Built-in SQL Types > https://www.postgresql.org/docs/15/xfunc-c.html#XFUNC-C-TYPE-TABLE > Does postgres have Equivalent C range Type for Built-in SQL range Types? > > No, there is only common ancestor - RangeType

Does postgres have Equivalent range C range Ty​pe for Built-in SQL range Types

Equivalent C Types for Built-in SQL Types https://www.postgresql.org/docs/15/xfunc-c.html#XFUNC-C-TYPE-TABLE Does postgres have Equivalent C range Type for Built-in SQL range Types? -- I recommend David Deutsch's <> Jian