Re: [GENERAL] Quotes, double quotes...

2013-09-29 Thread hubert depesz lubaczewski
On nie, wrz 29, 2013 at 02:09:54 +0100, António M. Rodrigues wrote: > The code is the following: > > - > DO $$ > DECLARE > i integer; > BEGIN > FOR i IN (select nn from numeros) > LOOP > EXECUTE > 'create table contagio' || i || ' as > SELECT

Re: [GENERAL] Quotes, double quotes...

2013-09-29 Thread Adrian Klaver
On 09/29/2013 08:31 AM, António M. Rodrigues wrote: Thanks for your reply. If I substitute double quotes with single quotes (or with double dollar sign", and run the code: DO $$ DECLARE i integer; BEGIN FOR i IN (select nn from numeros) LOOP EXECUTE 'create table contagio' || i || ' as SEL

Re: [GENERAL] Quotes, double quotes...

2013-09-29 Thread António M . Rodrigues
Thanks for your reply. If I substitute double quotes with single quotes (or with double dollar sign", and run the code: DO $$ DECLARE i integer; BEGIN FOR i IN (select nn from numeros) LOOP EXECUTE 'create table contagio' || i || ' as SELECT * FROM pgr_drivingdistance(' SELECT gid AS i

Re: [GENERAL] Quotes, double quotes...

2013-09-29 Thread Adrian Klaver
On 09/29/2013 06:09 AM, António M. Rodrigues wrote: Hi all, I have a problem with quotes which I can't find a solution. Inside a query string I have another query string; I used for the later double quotes, but it is still complaining The problem is with the function pgr_drivingdistance (from

[GENERAL] Quotes, double quotes...

2013-09-29 Thread António M . Rodrigues
Hi all, I have a problem with quotes which I can't find a solution. Inside a query string I have another query string; I used for the later double quotes, but it is still complaining The problem is with the function pgr_drivingdistance (from pgrouting extension). The code is the following: ---