The following CREATE FUNCTION request uses the NEW construct in its RETURN statement and specifies the geospatial data type ST_GEOMETRY in its RETURNS clause and its RETURN statement.
CREATE FUNCTION test.geospatial_type_UDF() RETURNS ST_GEOMETRY LANGUAGE SQL DETERMINISTIC CONTAINS SQL SPECIFIC test.geospatial_type_UDF CALLED ON NULL INPUT SQL SECURITY DEFINER COLLATION INVOKER INLINE TYPE 1 RETURN NEW ST_GEOMETRY('POINT (1,2)');