GBase 8c支持PostGIS

PostGIS是空间数据库扩展器，它增加了对地理对象的支持，允许在 SQL 中运行位置查询。

WITH city AS (

  SELECT 'Gotham' AS name,

    ST_Buffer(ST_Point(0,0), 10) AS geom)

 , superhero(name,geom) AS (

    VALUES

      ('Bat Boy', ST_Point(0.1,0))

    , ('Bat Girl', ST_Point(1,1) ))SELECT superhero.nameFROM city INNER JOIN superhero

    ON ST_Contains(city.geom, superhero.geom)WHERE city.name = 'Gotham';