thank you Sergio.
I decided to use
EXECUTE v_stmt into v_total_pop;
On Thu, Sep 4, 2008 at 2:00 PM, Ivan Sergio Borgonovo
<[EMAIL PROTECTED]>wrote:
> On Thu, 4 Sep 2008 13:41:16 -0700
> "Ruben Gouveia" <[EMAIL PROTECTED]> wrote:
>
> > I created a simple function that i want to use another func
On Thu, 4 Sep 2008 13:41:16 -0700
"Ruben Gouveia" <[EMAIL PROTECTED]> wrote:
> I created a simple function that i want to use another function
> (in the same schema) that will be used to create a sql statement.
> I get the following error when i try this:
>
> *ERROR: syntax error at or near "EXE
I created a simple function that i want to use another function (in the same
schema) that will be used to create a sql statement. I get the following
error when i try this:
*ERROR: syntax error at or near "EXEC" at character 1
QUERY: EXEC SQL EXECUTE $1 INTO $2
CONTEXT: SQL statement in PL/P
n Gouveia
>Enviado el: Jueves, 04 de Septiembre de 2008 16:37
> Para: pgsql-sql@postgresql.org
>Asunto: [SQL] Syntax help please
>
>
>I can't for the life of me figure out what's wrong with this syntax.
> I get the following error when i try and
PROTECTED] En nombre de Ruben Gouveia
Enviado el: Jueves, 04 de Septiembre de 2008 16:37
Para: pgsql-sql@postgresql.org
Asunto: [SQL] Syntax help please
I can't for the life of me figure out what's wrong with this syntax.
I get the followi
I can't for the life of me figure out what's wrong with this syntax. I get
the following error when i try and create this function.
*ERROR: syntax error at or near "$2" at character 15
QUERY: SELECT $1 $2 := $3 || $4 || $5
CONTEXT: SQL statement in PL/PgSQL function "fcn_gen_statement
