New answers tagged postgis
UPDATE mytbl SET col2=myfn(col1) should do the trick
Seems you are running in a weakness of the query planner: The best index is sometimes not used for joining tables. Had a similar problem here: Algorithm for finding the longest prefix (Chapter "Failed attempt with text_pattern_ops") In Postgres 9.3 You could try this version with LEFT JOIN LATERAL: SELECT * FROM ( SELECT coord FROM ...
Top 50 recent answers are included