Re: Add support for data change delta tables

2024-01-16 Thread Jim Nasby
On 1/15/24 4:40 AM, Pavel Stehule wrote: PostgreSQL is not a project where somebody says, you will do this, and you will do this, in this and this priority. There are a lot of nice features from standard - SQL standard is big, but a) you have to have funds to pay the developers, b) you have to

Re: Add support for data change delta tables

2024-01-15 Thread Adrian Klaver
Doe', '555-2323' ) ) AS t PostgreSQL has RETURNING that provides only a subset of this functionality. So I suggest to add support for data change delta tables. Because this feature  is more powerful and it is included in the SQL Standard. I don't know that syntax, but it seems to

Re: Add support for data change delta tables

2024-01-15 Thread Thomas Kellerer
27;555-2323' ) > ) AS t > > PostgreSQL has RETURNING that provides only a subset of this functionality. > > So I suggest to add support for data change delta tables. Because this  > feature is more powerful and it is included > in the SQL Standard. I don't know that sy

Re: Add support for data change delta tables

2024-01-15 Thread Pavel Stehule
FROM NEW TABLE ( >>> INSERT INTO phone_book >>> VALUES ( 'Peter Doe', '555-2323' ) >>> ) AS t >>> >>> >>> PostgreSQL has RETURNING that provides only a subset of this functionality. >>> >>> >&

Re: Add support for data change delta tables

2024-01-15 Thread PavelTurk
S t PostgreSQL has RETURNING that provides only a subset of this  functionality. So I suggest to add support for data change delta tables. Because this  feature is more powerful and it is included in the SQL Standard. This is the wrong mailing list - probably you s

Re: Add support for data change delta tables

2024-01-15 Thread Pavel Stehule
elta tables. For example, >> it doesn't support this type of query: >> >> SELECT * FROM NEW TABLE ( >> INSERT INTO phone_book >> VALUES ( 'Peter Doe', '555-2323' ) >> ) AS t >> >> >> PostgreSQL has RETURNIN

Re: Add support for data change delta tables

2024-01-15 Thread PavelTurk
ELECT * FROM NEW TABLE (  INSERT INTO phone_book  VALUES ( 'Peter Doe', '555-2323' ) ) AS t PostgreSQL has RETURNING that provides only a subset of this functionality. So I suggest to add support for data change delta tables. Because this  feature is mor

Re: Add support for data change delta tables

2024-01-15 Thread Pavel Stehule
VALUES ( 'Peter Doe', '555-2323' ) > ) AS t > > PostgreSQL has RETURNING that provides only a subset of this functionality. > > > So I suggest to add support for data change delta tables. Because this > feature is more powerful and it is included > in th

Add support for data change delta tables

2024-01-15 Thread PavelTurk
provides only a subset of this functionality. So I suggest to add support for data change delta tables. Because this feature  is more powerful and it is included in the SQL Standard. Best regards, Pavel