[pgbr-geral] Como faz Select dentro do for loop?

Fri, 06 Jan 2017 04:24:07 -0800 

Por exemplo:
FOR rResult IN SELECT lote FROM fatura WHERE ORDER BY loteLOOP

 SELECT   MIN(fatura.inicio) INTO inicio , MAX(fatura.termino) INTO termino 
FROM fatura WHERE lote = r.lote;  RAISE NOTICE '%',lote || '' || inicio||' 
'||termino; END LOOP;
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Responder a