Add support for data change delta tables

From: PavelTurk <pavelturk2000(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Add support for data change delta tables
Date: 2024-01-15 10:00:19
Message-ID: 4f12dcdb-6d17-22a9-14e7-c006c97f5fab@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello all,

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.

Best regards, Pavel

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2024-01-15 10:05:47 Re: Add support for data change delta tables
Previous Message veem v 2024-01-15 04:16:47 Moving to Postgresql database