Postgres Pro
Downloads
Home   >   mailing lists

is there an immutable function to switch from date to character? - Mailing list pgsql-general

From Celia McInnis
Subject is there an immutable function to switch from date to character?
Date
Msg-id CAGD6t7+GykxBs=BVeg2un_rQOrjXz==pXt-UWFVTNCgeYCSB5A@mail.gmail.com
Whole thread Raw
Responses Re: is there an immutable function to switch from date to character?  (Steve Baldwin <steve.baldwin@gmail.com>)
Re: is there an immutable function to switch from date to character?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Backup_Long Running
Next
From: Steve Baldwin
Date:
Subject: Re: is there an immutable function to switch from date to character?