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;
Sorry, try
select into numRegistros count(*) from base.emissor_ponto_venda where
id = PontoVenda_Emissor;
The thing you are selecting into needs to match what you are
selecting. So in your examples below, record is needed when you use
"* from ...". If you just need to look at one value:
Rodrigues da Rocha
To: pgsql-sql@postgresql.org
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
On Aug 31, 2006, at 9:00 AM, Ezequias Rodrigues da Rocha wrote:
select count(id) as numRegistros from base.emissor_ponto_venda
where id = PontoVenda_Emissor;
declare numRegistros as an integer in the declarations section and
rewrite the select:
select into numRegistros count(id) from ba
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
