Re: ST_AsMVTGeom AND table name as parameter in pl/psql - Mailing list pgsql-hackers

From Tom Lane
Subject Re: ST_AsMVTGeom AND table name as parameter in pl/psql
Date
Msg-id 1503792.1600266365@sss.pgh.pa.us
Whole thread Raw
In response to ST_AsMVTGeom AND table name as parameter in pl/psql  (James McManus <jmpmcmanus@gmail.com>)
List pgsql-hackers
James McManus <jmpmcmanus@gmail.com> writes:
> However, when I try and use EXECUTE in the mvtgeom AS section of the script
> I get a syntax error on EXECUTE:

You need to convert the *entire* query into a string and apply EXECUTE
to that.  You can't use EXECUTE as a part of a query.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Adam Brusselback
Date:
Subject: Re: Proposal of new PostgreSQL Extension - PGSpiderExt
Next
From: Julien Rouhaud
Date:
Subject: Re: Proposal of new PostgreSQL Extension - PGSpiderExt