我有一个查询，它从最后一行上的一列中获取GeoJSON值，该值被转换为几何图形，并用这个新值更新同一行上的其他列。
UPDATE table-name
SET geometria = (SELECT ST_GeomFromText(
ST_AsText(
CAST(ST_GeomFromGeoJSON(t1.column-name) AS TEXT)
), 4326
)
FROM (SELECT column-name
FROM table-name
ORDER BY id DESC
LIMIT 1) AS t1)
WHERE id IN(SELECT id
FROM table-name
ORDER BY id DESC
LIMIT 1
);现在我只接受最后插入的行，如何将此查询与触发器一起使用，该查询将用于每一行？
转载请注明出处:http://www.yihangfood.com/article/20230526/2241287.html