Re: [SQL] ERROR: SELECT query has no destination for result data

[Joe]

Ezequias Rodrigues da Rocha wrote:

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;

You haven't declared numRegistros.

Joe

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq