Tag Info

New answers tagged

3

UPDATE mytbl SET col2=myfn(col1) should do the trick


0

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