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 1rPJlh-00AkXy-1G for pgsql-general@arkaria.postgresql.org; Mon, 15 Jan 2024 10:00:33 +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 1rPJlf-00Ec82-9X for pgsql-general@arkaria.postgresql.org; Mon, 15 Jan 2024 10:00:31 +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 1rPJle-00Ec7u-Op for pgsql-general@lists.postgresql.org; Mon, 15 Jan 2024 10:00:30 +0000 Received: from mail-lj1-x229.google.com ([2a00:1450:4864:20::229]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rPJlX-001d7E-VR for pgsql-general@lists.postgresql.org; Mon, 15 Jan 2024 10:00:29 +0000 Received: by mail-lj1-x229.google.com with SMTP id 38308e7fff4ca-2cd703e9014so73490581fa.1 for ; Mon, 15 Jan 2024 02:00:23 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1705312821; x=1705917621; darn=lists.postgresql.org; h=content-language:content-transfer-encoding:mime-version:user-agent :date:message-id:subject:from:to:from:to:cc:subject:date:message-id :reply-to; bh=GWukYO3jE0mi+Y1j+u9fzTBFewkrEnS2v1tmK7pstWk=; b=eX0IptuKAsTXRW0YcA8iaq9a7y+spzGW4fV+qpAWeeo3Xj5kspbI7RovHP+xXTqPI3 aCaWcKFLTqWW2JFldDQte+rGQ4Az3LxSAx7SCEua88akfLt15ILpgHPku2y2SZaOXlMx 0E49PHiHDcfIpj/nKbuXOXN4dgS0kMgjto3Yz2rss2NwZr+uP+gGqlPl5ro+77Usyfhl TOVHAyK0fq1zPgoT1cERcX6vAOOSbHiCseGyaAHtgrkZO2U57xOPRIdMNtwmZkf4Fq7w F4jEm2W/pMXQdDi8Y3HvLyU8PdkwOj4LBXlP9qn+IDO7mEu1Vxivp4qgxasDhgsuyXAv 5ztQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1705312821; x=1705917621; h=content-language:content-transfer-encoding:mime-version:user-agent :date:message-id:subject:from:to:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=GWukYO3jE0mi+Y1j+u9fzTBFewkrEnS2v1tmK7pstWk=; b=I7EZ/NN3Aj3sd/UR4R2EFG5MMXIpboIXnKyJpSTcNvM9UdULbTMspoQe1/uONtEk2R hwVH8Ykm7XyXo1rhMtLGSYlJaKMJ29+qwCB/7MQqijz9j3gNcOn9Q4pBzZ0KDM51ltCH Su/48wD7HojqdUjSeV3NPjG+Ajz5Zj7W8ImRHAXGoz8eqjG60aQkjSp0/u6gL5gOkgVN hNGEB4VnZatzMPXJF7WNcsIaxMpKQAVtgsZkG+LAyG20Si1Yoz7mtcGl49V7C1zXs4aq uG3v9lkmkKj2x/Bk6+tpOBmeHnjB3Ve2Xe/jQ5SV2s6cHFctX+cOGsbUGJFXf4a5nXm8 m8aw== X-Gm-Message-State: AOJu0YxVN6JH/GcVKlNoV5XZcfTCRA46OaUj43x7f83EawBjS9Pu5PRI +f2TRKoDhgu17E9tEu0Cd2wuqAv4tic= X-Google-Smtp-Source: AGHT+IEerrYurZjHdruNfHTIzn8yMFpf3UMmTil/eW2LABP3Y/rKvjfH0rrlHZ7FAJ1frtsN9jWT2Q== X-Received: by 2002:a2e:9b8e:0:b0:2cd:2c8d:1ee6 with SMTP id z14-20020a2e9b8e000000b002cd2c8d1ee6mr2580856lji.83.1705312821024; Mon, 15 Jan 2024 02:00:21 -0800 (PST) Received: from [192.168.0.101] ([92.114.142.154]) by smtp.gmail.com with ESMTPSA id qc21-20020a170906d8b500b00a26ac5e3683sm5085777ejb.100.2024.01.15.02.00.20 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 15 Jan 2024 02:00:20 -0800 (PST) To: pgsql-general@lists.postgresql.org From: PavelTurk Subject: Add support for data change delta tables Message-ID: <4f12dcdb-6d17-22a9-14e7-c006c97f5fab@gmail.com> Date: Mon, 15 Jan 2024 12:00:19 +0200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.13.0 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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