Horton
Menu

Re: Feature Proposal: Column-Level DELETE Operation in SQL

Karsten Hilbert <karsten.hilbert@gmx.net>

View thread
From: Karsten Hilbert <Karsten.Hilbert@gmx.net>
To: pgsql-general@lists.postgresql.org, pgsql-general@postgresql.org
Date: 2025-04-22T12:26:07Z
Lists: pgsql-general 
Am Mon, Apr 21, 2025 at 10:23:30PM +0530 schrieb Abhishek Hatgine:

>    *deleting* a value is conceptually different from *updating* it to NULL.

In what way ?

In other words, you'll have to much better define what you
mean be "deleting a value".

DROP COLUMN already exists, for that matter.

Updating a column to its DEFAULT value may also be closer to
what you envision a "column-delete" to do.

Karsten
-- 
GPG  40BE 5B0E C98E 1713 AFA6  5BC0 3BEA AC80 7D4F C89B