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
' )
) 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
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
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 su
as 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 should send your proposal to
p
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 RETURNING that provides only a su
OM 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 in
ES ( '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.
>
This is
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
