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

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 base.emissor_ponto_venda  
where id = PontoVenda_Emissor;

See http://www.postgresql.org/docs/8.1/interactive/plpgsql- 
statements.html#PLPGSQL-SELECT-INTO




John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL