|
Ezequias,
Declare a variavel numRegistros
dentro da funcao e altere o SELECT p/
select count(id) INTO numRegistros from
base.emissor_ponto_venda where id = PontoVenda_Emissor;
q vai dar certo, OK ??
SPS
2000Info
----- Original Message -----
Sent: Thursday, August 31, 2006 10:00
AM
Subject: [SQL] ERROR: SELECT query has no
destination for result data
Hi
list,
I have a function like this:
Create OR REPLACE Function
base.inserirPontos(char(1), varchar(255), numeric(12,2), int8, int8, int8 )
returns int4 as
$$
declare
Operacao alias for
$1;
Numero_nota alias for
$2;
Valor_nota alias for
$3;
PontoVenda_Emissor
alias for $4;
Cardpass alias for
$5;
Cx_Id alias for
$6;
begin
-- Validando parâmetros passados na
função
if Operacao <> 'C'
then
return
1;
else
select
count(id) as numRegistros from base.emissor_ponto_venda where id =
PontoVenda_Emissor;
if numRegistros
= 0 then
return 2;
else
insert into base.pontos values (nextval('base.ponto_id'), now(), Operacao,
Numero_nota, Valor_nota, PontoVenda_Emissor, CartaoId(Cardpass), Cx_id);
return 0;
end if;
end if;
end
$$
LANGUAGE 'plpgsql'
And I am getting the following result
when I try to insert using the function:
select base.inserirPontos('C', '123456789', 12.5, 1,
9877000000944005, 104)
ERROR: SELECT query has no destination for
result data
HINT: If you want to discard the results,
use PERFORM instead.
CONTEXT: PL/pgSQL function "inserirpontos"
line 17 at SQL statement
What I did wrong ? Any suggestion is quite
good please.
ps:
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Atenciosamente
(Sincerely)
Ezequias
Rodrigues da
Rocha
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A
pior das democracias ainda é melhor do que a melhor das ditaduras
The worst
of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/
No virus found in this incoming message.
Checked by AVG Free
Edition.
Version: 7.1.405 / Virus Database: 268.11.7/434 - Release Date:
30/8/2006
|
