MIME-Version: 1.0
From: Celia McInnis <celia.mcinnis@gmail.com>
Date: Mon, 22 Apr 2024 15:42:09 -0400
Message-ID: <CAGD6t7L68jXK6jOLHhyRijSE1y-Y_pic9RZaNyBG+-QY4pa=6Q@mail.gmail.com>
Subject: altering a column to to make it generated
To: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000bacc300616b4a207"
Archived-At: <https://www.postgresql.org/message-id/CAGD6t7L68jXK6jOLHhyRijSE1y-Y_pic9RZaNyBG%2B-QY4pa%3D6Q%40mail.gmail.com>
Precedence: bulk

--000000000000bacc300616b4a207
Content-Type: text/plain; charset="UTF-8"

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 FROM rdrtime::interval)) STORED;
ERROR:  syntax error at or near "generated"
LINE 1: ... table tmp1 alter column avgspd type numeric(7,3) generated ...

I think that at least I have the right bracketing this time! :-)
                                                 ^

--000000000000bacc300616b4a207
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Can I alter a table column to now make it generated? =
I tried this unsuccessfully:</div><div><br></div><div>create temp table tmp=
1 as select 15::numeric(6,1) as distance,&#39;24:30&#39;::interval,0::numer=
ic(7,3) as avgspd;</div><div>alter table tmp1 alter column avgspd type nume=
ric(7,3) generated always as ((3600.*distance)/EXTRACT (EPOCH FROM rdrtime:=
:interval)) STORED;<br>ERROR: =C2=A0syntax error at or near &quot;generated=
&quot;<br>LINE 1: ... table tmp1 alter column avgspd type numeric(7,3) gene=
rated ...</div><div><br></div><div>I think that at least I have the right b=
racketing this time! :-)=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0=C2=A0 ^<br></div><div><br></div><div><br></div><div><br></div=
><div><br></div></div>

--000000000000bacc300616b4a207--