Re: [ADMIN] dynamic SQL

2008-09-10 Thread Scott Marlowe
On Wed, Sep 10, 2008 at 9:45 AM, davyd <[EMAIL PROTECTED]> wrote: > Hi list, > I need to create a sql where the name of a tabla is on a variable.. > > vbuffervarchar; > > SELECT buffer > INTO vbuffer > FROM rutas r, unidades u > WHEREr.codigo_ruta = u.codigo_ruta AND > u.cod

[ADMIN] dynamic SQL

2008-09-10 Thread davyd
Hi list, I need to create a sql where the name of a tabla is on a variable.. *vbuffer * varchar; SELECT buffer INTO vbuffer FROM rutas r, unidades u WHEREr.codigo_ruta = u.codigo_ruta AND u.codigo_uni = 'B15_AFF666'; SELECT within(the_geom,(SELECT geomunion(the_geom) from