Re: IMMUTABLE function to cast enum to/from text?

[Philip Semanchuk <philip@xxxxxxxxxxxxxxxxxxxxx>]

> On Nov 10, 2022, at 3:39 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
> 
> Joe Conway <mail@xxxxxxxxxxxxx> writes:
>> 
>> CREATE OR REPLACE FUNCTION mood2text(mood)
>> RETURNS text AS
>> $$
>>  select $1
>> $$ STRICT IMMUTABLE LANGUAGE sql;
> 
> Of course, what this is doing is using a SQL-function wrapper to
> lie about the mutability of the expression.  Whether you consider
> that elegant is up to you ;-) ... but it should work, as long as
> you don't break things by renaming the enum's values.


Thanks Joe and Tom,
I’m comfortable lying to Postgres occasionally — never for evil, only for good of course. :-)


Cheers
Philip