ERROR: SELECT query has no destination for result data - Mailing list pgsql-sql

Hi list,<br /><br />I have a function like this:<br /><br /><font size="1"><span style="font-family:
arial,sans-serif;">CreateOR REPLACE Function base.inserirPontos(char(1), varchar(255), numeric(12,2), int8, int8, int8
)returns int4 as </span><br style="font-family: arial,sans-serif;" /><span style="font-family:
arial,sans-serif;">$$</span><brstyle="font-family: arial,sans-serif;" /><span style="font-family:
arial,sans-serif;">declare</span><brstyle="font-family: arial,sans-serif;" /><span style="font-family:
arial,sans-serif;">   Operacao alias for $1;</span><br style="font-family: arial,sans-serif;" /><span
style="font-family:arial,sans-serif;">    Numero_nota alias for $2;</span><br style="font-family: arial,sans-serif;"
/><spanstyle="font-family: arial,sans-serif;">    Valor_nota alias for $3;</span><br style="font-family:
arial,sans-serif;"/><span style="font-family: arial,sans-serif;">    PontoVenda_Emissor alias for $4;</span><br
style="font-family:arial,sans-serif;" /><span style="font-family: arial,sans-serif;">    Cardpass alias for
$5;</span><brstyle="font-family: arial,sans-serif;" /><span style="font-family: arial,sans-serif;">    Cx_Id alias for
$6;</span><spanstyle="font-family: arial,sans-serif;"> </span><br style="font-family: arial,sans-serif;" /><br
style="font-family:arial,sans-serif;" /><span style="font-family: arial,sans-serif;">begin</span><br
style="font-family:arial,sans-serif;" /><br style="font-family: arial,sans-serif;" /><span style="font-family:
arial,sans-serif;">--Validando parâmetros passados na função</span><br style="font-family: arial,sans-serif;" /><br
style="font-family:arial,sans-serif;" /><span style="font-family: arial,sans-serif;">   if Operacao <> 'C'
then</span><brstyle="font-family: arial,sans-serif;" /><span style="font-family: arial,sans-serif;">     return
1;</span><brstyle="font-family: arial,sans-serif;" /><span style="font-family: arial,sans-serif;">    else</span><br
style="font-family:arial,sans-serif;" /><span style="font-family: arial,sans-serif;">     select count(id) as
numRegistrosfrom base.emissor_ponto_venda where id = PontoVenda_Emissor; </span><br style="font-family:
arial,sans-serif;"/><span style="font-family: arial,sans-serif;">     if numRegistros = 0 then</span><br
style="font-family:arial,sans-serif;" /><span style="font-family: arial,sans-serif;">        return 2;         
</span><brstyle="font-family: arial,sans-serif;" /><span style="font-family: arial,sans-serif;">      else</span><br
style="font-family:arial,sans-serif;" /><span style="font-family: arial,sans-serif;">        insert into base.pontos
values(nextval('base.ponto_id'), now(), Operacao, Numero_nota, Valor_nota, PontoVenda_Emissor, CartaoId(Cardpass),
Cx_id);</span><br style="font-family: arial,sans-serif;" /><span style="font-family: arial,sans-serif;">        return
0;  </span><br style="font-family: arial,sans-serif;" /><span style="font-family: arial,sans-serif;">     end if;
</span><brstyle="font-family: arial,sans-serif;" /><span style="font-family: arial,sans-serif;">  end if;</span><br
style="font-family:arial,sans-serif;" /><span style="font-family: arial,sans-serif;">end</span><br style="font-family:
arial,sans-serif;"/><br style="font-family: arial,sans-serif;" /><span style="font-family:
arial,sans-serif;">$$</span><brstyle="font-family: arial,sans-serif;" /><span style="font-family:
arial,sans-serif;"> LANGUAGE'plpgsql'</span><br style="font-family: arial,sans-serif;" /><br style="font-family:
arial,sans-serif;"/><span style="font-family: arial,sans-serif;">And I am getting the following result when I try to
insertusing the function:</span></font><br /><br /><span style="font-weight: bold;"> select base.inserirPontos('C',
'123456789',12.5, 1, 9877000000944005, 104)</span><br /><br /><br /><span style="color: rgb(255, 0, 0);">ERROR:  SELECT
queryhas no destination for result data</span><br style="color: rgb(255, 0, 0);" /><span style="color: rgb(255, 0,
0);">HINT: If you want to discard the results, use PERFORM instead.</span><br style="color: rgb(255, 0, 0);" /><span
style="color:rgb(255, 0, 0);">CONTEXT:  PL/pgSQL function "inserirpontos" line 17 at SQL statement <br /><br />What I
didwrong ? Any suggestion is quite good please.<br /><br />ps: <br style="color: rgb(255, 0, 0);" /></span><br />-- <br
/>=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-<br
/>                                  Atenciosamente(Sincerely) <br />                        Ezequias Rodrigues da
Rocha<br/> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-<br />A pior das democracias ainda é
melhordo que a melhor das ditaduras<br />The worst of democracies is still better than the better of dictatorships <br
/><ahref="http://ezequiasrocha.blogspot.com/">http://ezequiasrocha.blogspot.com/</a>