Re: Select (1-3)

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Ezequias Rodrigues da Rocha <ezequias(dot)rocha(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Select (1-3)
Date: 2006-11-30 18:36:50
Message-ID: 20061130183649.GF19218@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Ezequias Rodrigues da Rocha wrote:
> Hi list,
>
> It is possible to make a selection like
>
> Select (list 1 to 1000);

Sure, use the generate_series() function.

select * from generate_series(1, 1000);

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

  • Select (1-3) at 2006-11-30 18:30:04 from Ezequias Rodrigues da Rocha

Browse pgsql-sql by date

  From Date Subject
Next Message Ezequias Rodrigues da Rocha 2006-11-30 18:43:11 Re: Select (1-3)
Previous Message Aaron Bono 2006-11-30 18:35:36 Re: Select (1-3)