Re: ALTER COLUMN ... SET EXPRESSION to alter stored generated column's expression

[Vik Fearing]

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