Home > mailing lists

Re: execute - Mailing list pgsql-sql

From	Jov
Subject	Re: execute
Date	April 26, 2013 03:57:42
Msg-id	CADyrUxMRwLp=CtrzLBwJ0VX=AwsbUWoCkNUXCwE-JFK=uJvHJA@mail.gmail.com Whole thread Raw
In response to	Re: execute (Sergey Konoplev <gray.ru@gmail.com>)
List	pgsql-sql

2013/4/26 Sergey Konoplev <gray.ru@gmail.com>

aCad:=aCad array[['||var1||','||var2||']]

do you want append array[['||var1||','||var2||']] to aCad？

you can do this:

declare tmpa text[] := array[]::text[];

...

tmpa:= tmpa || var1 || var2;

aCad:= aCad || tmpa;

...

execute in plpgsql can ruan any pg sql command,but

aCad:=aCad array[['||var1||','||var2||']]

is not a command, it is a statement in plpgsql, a PART of plpgsql cmd.

--
Jov

From: Sergey Konoplev
Date: 26 April 2013, 03:21:48
Subject: Re: execute

From: Jasen Betts
Date: 27 April 2013, 10:01:01
Subject: Re: execute