The update trigger procedure is similarly modified.
对更新触发器过程进行相似的修改。
In the update trigger, you need to delete the corresponding feature if one of the coordinates becomes null.
在更新触发器中,如果坐标值之一变成null,那么需要删除对应的特性。
The update trigger is more complicated: if the update causes an exception, you have to delete the existing feature row, just as for null coordinates.
更新触发器比较复杂:如果更新导致异常,那么必须删除现有的特性行,就像处理null坐标一样。
When either of the coordinate columns in the source table is updated, a new point geometry must be constructed. The update trigger looks like this
当更新源表中的坐标列时,必须构造一个新的点几何值。
When either of the coordinate columns in the source table is updated, a new point geometry must be constructed. The update trigger looks like this
当更新源表中的坐标列时,必须构造一个新的点几何值。
应用推荐