Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rPJwD-00Almk-MU for pgsql-general@arkaria.postgresql.org; Mon, 15 Jan 2024 10:11:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rPJwC-00EiLB-JQ for pgsql-general@arkaria.postgresql.org; Mon, 15 Jan 2024 10:11:24 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rPJwC-00EiL3-8h for pgsql-general@lists.postgresql.org; Mon, 15 Jan 2024 10:11:24 +0000 Received: from mail-wm1-x333.google.com ([2a00:1450:4864:20::333]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rPJw7-001dB3-3k for pgsql-general@lists.postgresql.org; Mon, 15 Jan 2024 10:11:23 +0000 Received: by mail-wm1-x333.google.com with SMTP id 5b1f17b1804b1-40e80046246so833735e9.1 for ; Mon, 15 Jan 2024 02:11:18 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1705313477; x=1705918277; darn=lists.postgresql.org; h=content-language:in-reply-to:mime-version:user-agent:date :message-id:from:references:cc:to:subject:from:to:cc:subject:date :message-id:reply-to; bh=/U80sJDdSxpCmAXEbRntNjoVszNtWXDBT0TsGJa1Vao=; b=DpByXLsLg8LLFvf3Hp0VS8sc+yD9Eitq0sfG7UQK2bNZ0roqdQTPs/V6I2N0ID6B6e 4WSOIIbkCxjRUe1VtXM8ol0wtpI3wAEQWRvuwM3dRD8m2lYe7KZNqTQLYQrhjK0orlwa GeFzcPGHW+VV4nl2wB4hdHkDkyhC2fBwFO0FqriDVNtKc8g4D1EAH4SKA+ux7UF6dhkl NqVikcqHICB9k5xN2A46CQh9A2QLCFu7BQn6bbFUvg9LmXhPn/CfVm7Az+b8rKsINZ5b 4sFhAT4v/SwP8zBFKQpkjDxWWno2XtuD4E/3X+/6sXYrraehVYUuORZODpfY1rsvGeMu n/Ug== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1705313477; x=1705918277; h=content-language:in-reply-to:mime-version:user-agent:date :message-id:from:references:cc:to:subject:x-gm-message-state:from:to :cc:subject:date:message-id:reply-to; bh=/U80sJDdSxpCmAXEbRntNjoVszNtWXDBT0TsGJa1Vao=; b=b6AZts/h1ZOYDb2+2YtyAvXTT3twDwwVUErLJO4YMh2BwrZkeK1MQwmXMc+jA8ceoU p6KrciE9BVg02ptka3MgHsQpXLSh9ekk7y1FF3GhTBw518VXX+nXyCUI8r2KUZlenjB8 RIq6p2tmnE+QNROw7xeIAbqE9IZWRXsWvU0rH5o+tDDRyMQnm4ZsOLC1olrB74Q1ZCT2 MTEeXWIW0RQH8Zhj0SriR8nXW5J/iMXtkZd6YdXlKEI9z1SA2qXZsWYf66qBDkQv7OOu f//OyEW0uC1LLdevLY3WqTsx2Jn9jb+Ul+9MY56U3KZGQ7Mqz1IKcKuuED/7XMJNVCrY eLvQ== X-Gm-Message-State: AOJu0YyobCv8D4xoasB8aAcDGBvwkbbrRDG2+VQ6a5q3Iac/uUkh/Pr2 Hra0Qj7pCz/6aDUFbGiU1z6+d1Q6kxs= X-Google-Smtp-Source: AGHT+IEpXTFujyn3SsXWFmUyZGUzigJ2lcst8p7rzle8WHBx2R+f0uJPGqRyi5PfMfUvsHfj6Kblxw== X-Received: by 2002:a05:600c:4f43:b0:40e:6194:ccfa with SMTP id m3-20020a05600c4f4300b0040e6194ccfamr2948064wmq.6.1705313476833; Mon, 15 Jan 2024 02:11:16 -0800 (PST) Received: from [192.168.0.101] ([92.114.142.154]) by smtp.gmail.com with ESMTPSA id n6-20020a5d51c6000000b00337a7a9961csm2881679wrv.81.2024.01.15.02.11.16 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 15 Jan 2024 02:11:16 -0800 (PST) Subject: Re: Add support for data change delta tables To: Pavel Stehule Cc: pgsql-general@lists.postgresql.org References: <4f12dcdb-6d17-22a9-14e7-c006c97f5fab@gmail.com> From: PavelTurk Message-ID: <24408e7c-6103-eec0-8048-594b15a5e7af@gmail.com> Date: Mon, 15 Jan 2024 12:11:15 +0200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.13.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------37A64D77FC14F620CC0971A5" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------37A64D77FC14F620CC0971A5 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit On 1/15/24 12:05 PM, Pavel Stehule wrote: > Hi > > po 15. 1. 2024 v 11:00 odesílatel PavelTurk > napsal: > > 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. > > > This is the wrong mailing list - probably you should send your proposal to pgsql-hackers. I sent message to pgsql-hackers https://www.postgresql.org/message-id/b85900eb-9e3c-e358-aa8f-5a27b30c17e7%40gmail.com but got no answer. I decided that my message was ignored because I used wrong mailing list. > The community development is based on patches. If you propose some feature,  usually you should implement it. Probably nobody will implement it instand you. I am Java developer - I wish, but I can't Best regards, Pavel --------------37A64D77FC14F620CC0971A5 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit
On 1/15/24 12:05 PM, Pavel Stehule wrote:
Hi

po 15. 1. 2024 v 11:00 odesílatel PavelTurk <pavelturk2000@gmail.com> napsal:
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.

This is the wrong mailing list - probably you should send your proposal to pgsql-hackers.

I sent message to pgsql-hackers https://www.postgresql.org/message-id/b85900eb-9e3c-e358-aa8f-5a27b30c17e7%40gmail.com
but got no answer. I decided that my message was ignored because I used wrong mailing list.

The community development is based on patches. If you propose some feature,  usually you should implement it. Probably nobody will implement it instand you.

I am Java developer - I wish, but I can't

Best regards, Pavel

--------------37A64D77FC14F620CC0971A5--