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

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

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

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, int8, int8

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

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:

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

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;