I'm trying to update a column with new geometry but am getting
ERROR: column "current_geom" is of type geometry but expression is of type boolean.
UPDATE this_table t1 SET "current_geom" = ST_Intersects(t2.point_geom,t2.geom) FROM other_table t2 WHERE t1.current_geom is null
I'm obviously doing something wrong but not sure why it doesn't accept it?
Using: PostgreSQL 9.6 and pgAdmin 4.2