Re: [GENERAL] Postgresql 9.1 - select statement with multiple "with-clauses" becomes very slow

Hi Alban, thanks a lot - didn't realize it was so simple. It works like a charm! Cheers Von: Alban Hertroys An: Opel Fahrer CC: "pgsql-general@postgresql.org" Gesendet: 13:25 Donnerstag, 3.Januar 2013 Betreff: Re: [GENERAL] Postgres

[GENERAL] Postgresql 9.1 - select statement with multiple "with-clauses" becomes very slow

I'm a noob in writing efficient Postgres queries, so I wrote a first function to query multiple linked tables using the PostGIS extension. The query should fetch data from multiple tables and finally give me a table with two columns. Here's the code: [code]     prepare getmydata(real,real,real)