On 1/15/24 02:44, Thomas Kellerer wrote:
PavelTurk schrieb am 15.01.2024 um 11:00:
Currently PostgreSQL doesn't support data change delta 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 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 me, it's basically this:
with t as (
INSERT INTO phone_book
VALUES ( 'Peter Doe', '555-2323' )
returning *
)
select *
from t;
There is also transition relations:
https://www.postgresql.org/docs/current/sql-createtrigger.html
though that involves creating a trigger on a table.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
