On 11/30/06, Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]> wrote:
Hi list, It is possible to make a selection like Select (list 1 to 1000); And get the rows ? producao=# select ...; row --------- 1 2 3 . . . 1000
*select * from generate_series(1, 1000);* See http://oreillynet.com/pub/a/databases/2006/09/07/plpgsql-batch-updates.html?page=2 -- ================================================================== Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com http://codeelixir.com ==================================================================