Francisco Olarte writes:
> On Tue, 22 Apr 2025 at 14:09, Abhishek Hatgine
> wrote:
>> However, there’s no specific, expressive way to delete the value of a column
>> directly. The typical workaround is to use:
>> UPDATE Customers SET Address = NULL WHERE CustomerID = 103;
>> While this works fin
On Mon, Apr 21, 2025 at 10:23:30PM +0530, Abhishek Hatgine wrote:
> These would act as a shortcut or expressive alias for setting one or more
> column values to NULL.
NULL values are not quite no-values, and setting some column of some row
to NULL is not quite the same as deleting the column from
> On Apr 21, 2025, at 09:53, Abhishek Hatgine
> wrote:
> However, there’s no specific, expressive way to delete the value of a column
> directly. The typical workaround is to use:
> UPDATE Customers SET Address = NULL WHERE CustomerID = 103;
I'm not sure I agree that's unexpressive. When yo
On Tue, 22 Apr 2025 at 14:09, Abhishek Hatgine
wrote:
...
> I'd like to propose a new feature for consideration in future versions of SQL
> — the ability to perform a column-level DELETE operation, allowing removal of
> specific column values without affecting the entire row.
You will need to e
. Johnston
Sent: Tuesday, April 22, 2025 9:52 AM
To: Abhishek Hatgine
Cc: pgsql-gene...@postgresql.org
Subject: Re: Feature Proposal: Column-Level DELETE Operation in SQL
***This email is from an external source. Only open links and attachments from
a Trusted Sender.***
On Monday, April 21, 2025
On Tue, 22 Apr 2025, 13:09 Abhishek Hatgine,
wrote:
Dear SQL Development Team,
>
> I hope this message finds you well.
>
> I'd like to propose a new feature for consideration in future versions of SQL
> — the ability to perform a column-level DELETE operation, allowing removal of
> specific colu
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’t have this paradigm, you can’t
remove columns from exist
On Mon, 2025-04-21 at 22:23 +0530, Abhishek Hatgine wrote:
> I'd like to propose a new feature for consideration in future versions of SQL
> — the ability
> to perform a column-level DELETE operation, allowing removal of specific
> column values
> without affecting the entire row.
In PostgreSQL,
On Tue, Apr 22, 2025 at 5:56 PM Karsten Hilbert wrote:
>
> 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
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.
Upd
10 matches
Mail list logo
