Given that on creation of a function it is a requirement to state the procedural language of calculation what happens if we try using Python?
Just so happens the calculation part of Python for Fahrenheit to Celsius syntatically is identical between SQL and Python sooo lets try this.
CREATE FUNCTION calcfp(integer) RETURNS integer AS 'SELECT ($1 - 32) * 5/9' LANGUAGE plpythonu RETURNS NULL ON NULL INPUT;
Yes they couldn’t just call python python it has to be plythonu.
This is what I got.So assuming I referred to Python correctly it would appear that I need to enable the use of python in postgres.
Given that I don’t know Python I am not going to install this as an extension but should you wish the following will be relevant;
Link to Create Language instruction
It has the following hightlighted instruction
Note: As of PostgreSQL 9.1, most procedural languages have been made into “extensions”, and should therefore be installed with CREATE EXTENSION not CREATE LANGUAGE. Direct use of CREATE LANGUAGE should now be confined to extension installation scripts. If you have a “bare” language in your database, perhaps as a result of an upgrade, you can convert it to an extension using CREATE EXTENSION langname FROM unpackage