Class Enumeration
java.lang.Object
org.postgresql.pljava.example.annotation.Enumeration
@SQLAction(provides="mood type",install="CREATE TYPE mood AS ENUM (\'sad\', \'ok\', \'happy\')",remove="DROP TYPE mood") @SQLAction(requires={"textToMood","moodToText","textsToMoods","moodsToTexts"},install={"SELECT textToMood(\'happy\')","SELECT moodToText(\'happy\'::mood)","SELECT textsToMoods(array[\'happy\',\'happy\',\'sad\',\'ok\'])","SELECT moodsToTexts(array[\'happy\',\'happy\',\'sad\',\'ok\']::mood[])"})
public class Enumeration
extends Object
Confirms the mapping of PG enum and Java String, and arrays of each, as
parameter and return types.
-
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionmoodsToTexts
(String[] ss) static String
moodToText
(String s) textsToMoods
(String[] ss) static String
textToMood
(String s)
-
Constructor Details
-
Enumeration
public Enumeration()
-
-
Method Details
-
textToMood
-
moodToText
-
textsToMoods
-
moodsToTexts
-