Search Postgresql Archives
is there an immutable function to switch from date to character?
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Subject
: is there an immutable function to switch from date to character?
From
: Celia McInnis <celia.mcinnis@xxxxxxxxx>
Date
: Wed, 24 Apr 2024 17:31:00 -0400
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
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Follow-Ups
:
Re: is there an immutable function to switch from date to character?
From:
Tom Lane
Re: is there an immutable function to switch from date to character?
From:
Steve Baldwin
Prev by Date:
Re: Backup_Long Running
Next by Date:
Re: is there an immutable function to switch from date to character?
Previous by thread:
Backup_Long Running
Next by thread:
Re: is there an immutable function to switch from date to character?
Index(es):
Date
Thread
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]
