3 -- also update the pgsql version of these!?
6 CREATE OR REPLACE FUNCTION core_enum_display_name(integer)
17 SELECT display_name INTO ret FROM core_enum
18 WHERE id=in_id LIMIT 1;
24 LANGUAGE plpgsql VOLATILE
27 ALTER FUNCTION core_enum_display_name(integer)
35 CREATE OR REPLACE FUNCTION core_enum_name(integer)
43 SELECT name INTO ret FROM core_enum
44 WHERE id=in_id LIMIT 1;
49 LANGUAGE plpgsql VOLATILE
51 ALTER FUNCTION core_enum_name(integer)
59 CREATE OR REPLACE FUNCTION core_enum_name_to_display_name(text,text)
63 in_etype ALIAS FOR $1;
68 SELECT display_name INTO ret FROM core_enum
69 WHERE name=in_name AND etype=in_etype LIMIT 1;
74 LANGUAGE plpgsql VOLATILE
76 ALTER FUNCTION core_enum_name_to_display_name(text,text)
83 CREATE OR REPLACE FUNCTION core_enum_id_by_name(text,text)
87 in_etype ALIAS FOR $1;
92 SELECT id INTO ret FROM core_enum
93 WHERE name=in_name AND etype=in_etype LIMIT 1;
98 LANGUAGE plpgsql VOLATILE
100 ALTER FUNCTION core_enum_id_by_name(text,text)