FOR record1 IN SELECT id, nome, email FROM pessoa ORDER BY RANDOM() LIMIT 5 LOOP //FAZ NADA return next; END LOOP;
FOR record2 IN SELECT id, nome, email FROM pessoa ORDER BY RANDOM() LIMIT 3 LOOP //FAZ NADA return next; END LOOP; FOR record3 IN SELECT id, nome, email FROM pessoa ORDER BY RANDOM() LIMIT 2 LOOP //FAZ NADA return next; END LOOP; 2009/11/25 Jorge Vilela <[email protected]> > Pessoal, > > Hoje precisei criar uma procedure com varios selects, que rodam varios (for > record in sql loop end loop). > > No fim precisava juntar os records de retorno de todos os selects... Algo > como: > > FOR record1 IN > SELECT id, nome, email FROM pessoa ORDER BY RANDOM() LIMIT 5 > LOOP > //FAZ NADA > END LOOP; > > FOR record2 IN > SELECT id, nome, email FROM pessoa ORDER BY RANDOM() LIMIT 3 > LOOP > //FAZ NADA > END LOOP; > > FOR record3 IN > SELECT id, nome, email FROM pessoa ORDER BY RANDOM() LIMIT 2 > LOOP > //FAZ NADA > END LOOP; > > RETURN record1+record2+record3 EMBARALHADOS; > > > Tem como? Dá pra fazer um "merge" embaralhando os records em um só e > retornando um set of tipos? > > > > Jorge Vilela > > _______________________________________________ > pgbr-geral mailing list > [email protected] > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral > > -- André Luiz Martins Pignata Integral Convênios Odontológicos Gerente de TI
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
