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

Reply via email to