Re: [postgis-users] TR: St_AsEwkt

2017-07-06 Thread Felix Kunde
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 certainly righ

[postgis-users] TR: St_AsEwkt

2017-07-06 Thread Olivier Leprêtre
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

Re: [postgis-users] column lock?

2017-07-06 Thread Giuseppe Broccolo
Hi Volker, 2017-07-05 15:39 GMT+02:00 : > Hi, > > is it possible to lock a column of a table? > > > i edit data via qgis, but not every colum should be editable... > In PostgreSQL you can revoke permission at column table. This is possible since (at least) the 8.4 version: https://www.postgresql

Re: [postgis-users] St_AsEwkt

2017-07-06 Thread Tom van Tilburg
Somehow I feel there is no need for plpgsql in what you are doing and that indeed the ST_AsEwkt is too much. I can't wrap my head around what this script is exactly trying to do though. Can you elaborate a bit on your use-case? What is the original data and what would you like to know from it? Be