Hi,
in general, don't use FOR loops if you just want to iterate over query results.
You can do that with plain SQL (or SQL function). You could try out the LATERAL
construct if you have FOR EACH use cases.
Cheers
Felix
Betreff: [postgis-users] TR: St_AsEwkt
Hi,
Yes, you're
Hi,
Yes, you're certainly right, there must be other way of doing that, it's an old
bigger script which I was revisiting. I just extracted a small part of it. It
uses pgplsql because the purpose is to create tables of results. Using
st_AsEwkt was the only way I found to get geometry from a