"David G. Johnston" writes:
> On Mon, Apr 22, 2024 at 12:42 PM Celia McInnis
> wrote:
>> Can I alter a table column to now make it generated? I tried this
>> unsuccessfully:
> I looked at all of the "alter table ... alter column" commands listed here:
>
On 4/22/24 12:42, Celia McInnis wrote:
Can I alter a table column to now make it generated? I tried this
unsuccessfully:
create temp table tmp1 as select 15::numeric(6,1) as
distance,'24:30'::interval,0::numeric(7,3) as avgspd;
alter table tmp1 alter column avgspd type numeric(7,3) generated
On Mon, Apr 22, 2024 at 12:42 PM Celia McInnis
wrote:
> Can I alter a table column to now make it generated? I tried this
> unsuccessfully:
>
I looked at all of the "alter table ... alter column" commands listed here:
https://www.postgresql.org/docs/current/sql-altertable.html
And none seem
Can I alter a table column to now make it generated? I tried this
unsuccessfully:
create temp table tmp1 as select 15::numeric(6,1) as
distance,'24:30'::interval,0::numeric(7,3) as avgspd;
alter table tmp1 alter column avgspd type numeric(7,3) generated always as
((3600.*distance)/EXTRACT (EPOCH
