Re: Add support for data change delta tables

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@aklaver.com