Geoserver使用OGC过滤器PropertyIsLike无法读取PostGIS Jsonb类型

错误提示：

code="internalEror"Rendering process falled, Layers: boylat shp_ 1 org,postgresq!.ut.PsQLException: ERRoR: function upperjisonb) does not existHint: No function matches the given name and arqument types, You might need to add explicit type castsPosition:447ERROR: function upper(jsonb)does not existHint: No function matches the given name and arqument types, You might need to add explicit type casts.Position:447

解决办法：使用JsonPointer Function函数

//jsonb示例
{
    "name": "city name",
    "description": "the city description",
    "districts": [
            {
                "name": "district1",
                "population": 2000
            },
            {
                "name": "district2",
                "population": 5000
    }]
    "population":
    {
        "average_age": 35,
        "toal": 50000
    }
}

使用方法：

jsonPointer(city, '/name').
jsonPointer(city, '/population/average_age').
jsonPointer(city, '/districts/0/name').

在OGC过滤器中可以这样使用:

<Rule>
    <Name>Cities</Name>
    <ogc:Filter>
        <ogc:PropertyIsEqualTo>
            <ogc:Function name="jsonPointer">
                <ogc:PropertyName>city</ogc:PropertyName>
                <ogc:Literal>/population/average_age</ogc:Literal>
            </ogc:Function>
            <ogc:Literal>35</ogc:Literal>
        </ogc:PropertyIsEqualTo>
    </ogc:Filter>
    <PointSymbolizer>
        <Graphic>
            <Mark>
                <WellKnownName>square</WellKnownName>
                <Fill>
                    <CssParameter name="fill">#FF0000</CssParameter>
                </Fill>
            </Mark>
            <Size>16</Size>   </Graphic>
    </PointSymbolizer>
</Rule>

参考文档：Geoserver官方文档
中文文档