MIME-Version: 1.0
From: Celia McInnis <celia.mcinnis@gmail.com>
Date: Wed, 24 Apr 2024 17:31:00 -0400
Message-ID: <CAGD6t7+GykxBs=BVeg2un_rQOrjXz==pXt-UWFVTNCgeYCSB5A@mail.gmail.com>
Subject: is there an immutable function to switch from date to character?
To: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000b5f8070616de6382"
Archived-At: <https://www.postgresql.org/message-id/CAGD6t7%2BGykxBs%3DBVeg2un_rQOrjXz%3D%3DpXt-UWFVTNCgeYCSB5A%40mail.gmail.com>
Precedence: bulk

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

create temporary table junk as select now()::date as evtdate;

alter table junk add column chardate text GENERATED ALWAYS AS
(to_char(evtdate,'YYYY-Mon-DD')) STORED;

ERROR:  generation expression is not immutable

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

<div dir=3D"ltr"><div>create temporary table junk as select now()::date as =
evtdate;</div><div><br></div><div>alter table junk add column chardate text=
 GENERATED ALWAYS AS (to_char(evtdate,&#39;YYYY-Mon-DD&#39;)) STORED;</div>=
<div><br></div>ERROR: =C2=A0generation expression is not immutable<br><br><=
/div>

--000000000000b5f8070616de6382--