Re: loops

On Tue, Jun 2, 2009 at 12:24 PM, John R Pierce <pierce(at)hogranch(dot)com> wrote:
> Esneiker wrote:
>>
>> Hello, can anybody tell me how to do loops in postgres?
>>
>
> SQL, the query language, has no such control structures.  SQL is a
> 'declarative' language rather than a procedural one.
>
> pl/pgsql stored procedures do, however, as they embed SQL in a procedural
> context. depesz posted the link to the appropriate docs.

you can simulate simple loops with 'generate_series' and other set
returning functions like unnest or equivalent:

insert into foo(foo_id) select generate_series(1,10) v;
insert into foo(val) select unnest(current_schemas(true));