Charles Viana escreveu:
So que esta retornando NULO. O execute executa a query so que não passa
o valor para a variavel nnn
2007/5/26, Luiz Rafael Culik Guimaraes <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>>:
Ola
Eu sugiro alterar oara
CREATE OR REPLACE FUNCTION execd(text) RETURNS integer AS
$BODY$
declara
nnn integer;
begin
/* $1 seria '(SELECT MAX(codgeral) FROM histviag.carga)' */
execute $1;
return nnn
end;$BODY$
LANGUAGE 'plpgsql' VOLATILE;
e passaria sua query como
select max(codgeral) into nnn FROM histviag.carga
De acordo com o manual:
http://www.postgresql.org/docs/8.2/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN
"SELECT INTO is not currently supported within EXECUTE."
[]s
Osvaldo
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
