Re: EXECUTE query INTO problem

Tk421 <vrobador@gmail.com> schrieb:

>    I've got a problem with a function: It receives two parameters, the  
> first, the table name, and the second, a where condition. The function  
> looks like this:
>
>    DECLARE
>       cod bigint;
>       query TEXT;
>
>    BEGIN
>       query = 'SELECT codigo FROM ' || $1 || ' WHERE ' || $2;
>
>       EXECUTE query INTO cod;
>       ·
>       ·
>       ·
>    END;
>
>    I've alwais get the same error, in the EXECUTE sentence: it says:  
> Error at or near NULL at character X

Wild guess: one or both parameters contains nothing, NULL. If you concat
a string with NULL, the result is NULL. And you can't execute a
NULL-command.



>
>    I've also tried declaring cod as row, but the error is the same.
>
>    Anybody can help me?

Please show us the complete function and how do you call this function.


Andreas
-- 
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°