[SQL] EXECUTE query INTO problem

[Tk421]

   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

   I've also tried declaring cod as row, but the error is the same.

   Anybody can help me?

   Thank you very much

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql