ERROR: SELECT query has no destination for result data
| От | Ezequias Rodrigues da Rocha |
|---|---|
| Тема | ERROR: SELECT query has no destination for result data |
| Дата | |
| Msg-id | 55c095e90608310600y18d382f2l5cc43410466bbd79@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: ERROR: SELECT query has no destination for result data
Re: ERROR: SELECT query has no destination for result data |
| Список | 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>
В списке pgsql-sql по дате отправления: