Indeed and the last two years in postgresql history have been very rich feature wise.
I have managed teams of database administrators for roughly 10 years. And I know that using those arcane features or depending too much on those capabilities has cost millions to my company.
Avoid implementing everything in a database.
Pushing for those plugins as alternative just shows how little one knows about the feature level of Oracle capabilities.