Tag Info

New answers tagged


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