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 1u7E2H-00Cwf1-Cz for pgsql-general@arkaria.postgresql.org; Tue, 22 Apr 2025 13:51:41 +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 1u7E2F-00EcWp-6C for pgsql-general@arkaria.postgresql.org; Tue, 22 Apr 2025 13:51:40 +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 1u7E2E-00EcWg-RA for pgsql-general@lists.postgresql.org; Tue, 22 Apr 2025 13:51:39 +0000 Received: from mail-ot1-x331.google.com ([2607:f8b0:4864:20::331]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u7E2B-001MSl-1g for pgsql-general@postgresql.org; Tue, 22 Apr 2025 13:51:36 +0000 Received: by mail-ot1-x331.google.com with SMTP id 46e09a7af769-72ffe63a391so2609023a34.1 for ; Tue, 22 Apr 2025 06:51:35 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1745329895; x=1745934695; darn=postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=S+sjOvaBjORJhZILCLkrXLyHN9Q+BbUGNXbL8YJwsSg=; b=gOyN12pW2vys5tJO76Jlzr2LkWiIQeabfRVIGWTJPPT0XN1J9MayGZAnmCbD782Vrb /QwnMsHYaXv0MI/CcBNSgx7uLGn32BfeATx6eiFO1zJD5odWfl13arFJaVqdAvKMmBNY X0Hbcce4+Qd+GTu4ayHW1Lduo5wpPfIEYwVyrYqtTbYouO+P2Du+o2rmfUU7i4h5iIg/ Js1WDBszIIAjbDg/E4bgY2fMcG/EcAimB2+n6l1+kgkMlDaSaC5g8uzxeI1gTBNuUiPC igX6n0CnFNvf+tisGyv6BlNt2qY0hjFgHvKVK+SGi7LvgiGACqkCUz0Jk4dGhUxbBOip y57g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1745329895; x=1745934695; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=S+sjOvaBjORJhZILCLkrXLyHN9Q+BbUGNXbL8YJwsSg=; b=hnsYZRt8LfoPMIn6nTQlGg9ip33GroCJvl9NpVk8vU4qixnExD3I57pZf30mWnryEp 8wIiyWpEP5iBwt+joc6nA+JQCVmu+Uhh7+mDiGGiqLG53R4bu3dW1N94ZMMvdbn0fPPO Rw9G7UeYFdypzOSid0JAgWwuMVkBt4c4N9iDsUeuw+E5nKNs7GI9JTCL5Uh+Jua01ehp AnN8JSKK4P1e8hPsU6lAXW/8z9w1mbg7XKMK/WD/Mvmv25RXzNpQePAi6QYXUsRvEHjj 8uNIGr0V8fUlc0/AHgzpgBugBx0+SFVKIT0jGRdxyCzyewCAxVKBF1P+ngoTAKqeoQ4t iAjA== X-Gm-Message-State: AOJu0Ywjsp4UCqigi1ahToLN/URYQ4ikDa8VPyHu5r1YIryEt288Vaii jV6ESnRv95Yk/bprdmMaTt7Y+8p/6LyAujJJ2kT0racsiHdht/KbpJN/2WOZXTHkz5de00jwBhl dykDPp28Vt6o4Yo8Suk3MWzh6JjI= X-Gm-Gg: ASbGncte6Qw+9/Fff8tauQrOiSM+0d1OS4iVYEe22BijaIw5Od5l4EF0C5cxuHH1kG1 d1B9O+Cx93XJ1M8EfH0us29s1C0AQHK2REW5qadI4X+YyPacZeDr3xJl3DzuYMCiCz5CGAgwRkw Tn75DpU+c8qWX7Ou/aDeJj X-Google-Smtp-Source: AGHT+IGCbBFa2DXx4CSmXMG/JkJ5GLnjSLnj4FROwuUumrheryI1iH8j+he4hkB10yaoRA3GIXGzncDXRjNEdYfnRXo= X-Received: by 2002:a05:6871:24ca:b0:29f:bdf0:f0f5 with SMTP id 586e51a60fabf-2d51df20f01mr9177092fac.17.1745329895413; Tue, 22 Apr 2025 06:51:35 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:ac9:5dc2:0:b0:589:13f9:e937 with HTTP; Tue, 22 Apr 2025 06:51:34 -0700 (PDT) In-Reply-To: References: From: "David G. Johnston" Date: Tue, 22 Apr 2025 06:51:34 -0700 X-Gm-Features: ATxdqUEucdtPp8bUPhcnco5PCv8gkJSE_xB-YVdK0UwTtR9-jBBGizDmmcqz0tg Message-ID: Subject: Re: Feature Proposal: Column-Level DELETE Operation in SQL To: Abhishek Hatgine Cc: "pgsql-general@postgresql.org" Content-Type: multipart/alternative; boundary="0000000000006ea11e06335e48de" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000006ea11e06335e48de Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Monday, April 21, 2025, Abhishek Hatgine wrote:. > > > - > > More intuitive for developers coming from languages or NoSQL systems > where fields can be "deleted" from an object/document. > > Why should this matter to us? We don=E2=80=99t have this paradigm, you c= an=E2=80=99t remove columns from existence on a per-row basis. David J. --0000000000006ea11e06335e48de Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Monday, April 21, 2025, Abhishek Hatgine <hatgineabhishek99@gmail.com> wrote:.

  • More intuitive for developers coming from languages or NoSQL systems whe= re fields can be "deleted" from an object/document.

=
Why should this matter to us?=C2=A0 We don=E2=80=99= t have this paradigm, you can=E2=80=99t remove columns from existence on a = per-row basis.

David J.

--0000000000006ea11e06335e48de--