public inbox for [email protected]
help / color / mirror / Atom feedRe: Feature Proposal: Column-Level DELETE Operation in SQL
2+ messages / 2 participants
[nested] [flat]
* Re: Feature Proposal: Column-Level DELETE Operation in SQL
@ 2025-04-22 12:26 Karsten Hilbert <[email protected]>
2025-04-22 13:28 ` Re: Feature Proposal: Column-Level DELETE Operation in SQL Amul Sul <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Karsten Hilbert @ 2025-04-22 12:26 UTC (permalink / raw)
To: [email protected]; 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Feature Proposal: Column-Level DELETE Operation in SQL
2025-04-22 12:26 Re: Feature Proposal: Column-Level DELETE Operation in SQL Karsten Hilbert <[email protected]>
@ 2025-04-22 13:28 ` Amul Sul <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Amul Sul @ 2025-04-22 13:28 UTC (permalink / raw)
To: [email protected]; pgsql-general
On Tue, Apr 22, 2025 at 5:56 PM Karsten Hilbert <[email protected]> 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 "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.
>
Agreed, this is a much better approach to achieve the same.
I am a bit skeptical about whether the proposed syntax will be
acceptable if it's not SQL standard, unless it's absolutely necessary
to support functionality that can't be achieved with the existing
syntax which is not the case here.
Regards,
Amul
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2025-04-22 13:28 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-04-22 12:26 Re: Feature Proposal: Column-Level DELETE Operation in SQL Karsten Hilbert <[email protected]>
2025-04-22 13:28 ` Amul Sul <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox