Postgres Pro
Downloads
Home   >   mailing lists

Re: ALTER COLUMN ... SET EXPRESSION to alter stored generated column's expression - Mailing list pgsql-hackers

From Vik Fearing
Subject Re: ALTER COLUMN ... SET EXPRESSION to alter stored generated column's expression
Date
Msg-id 8ec6124c-d579-c6dc-1900-46849c066c9a@postgresfriends.org
Whole thread Raw
In response to ALTER COLUMN ... SET EXPRESSION to alter stored generated column's expression  (Amul Sul <sulamul@gmail.com>)
List pgsql-hackers
Tree view 
On 8/2/23 12:35, Amul Sul wrote:
> Hi,
> 
> Currently, we have an option to drop the expression of stored generated
> columns
> as:
> 
> ALTER [ COLUMN ] column_name DROP EXPRESSION [ IF EXISTS ]
> 
> But don't have support to update that expression. The attached patch
> provides
> that as:
> 
> ALTER [ COLUMN ] column_name SET EXPRESSION expression

I am surprised this is not in the standard already.  I will go work on that.
-- 
Vik Fearing

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: list of acknowledgments for PG16
Next
From: Vik Fearing
Date:
Subject: Re: list of acknowledgments for PG16