On Tue, Jun 2, 2009 at 12:24 PM, John R Pierce <pierce@hogranch.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));