Rodrigo De Leon
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] CREATE TABLE AS inside of a function
Rodrigo De Leon wrote:
> On 7/21/06, Kevin Nikiforuk <[EMAIL PROTECTED]> wrote:
>> So now that I've got my loops working, on to my next newbie
>> question. I've c
So now that I've got my loops working, on to my next newbie question. I've
created my function and in it, I want to loop through the results of a select
and for each value of my loop counter, I want to create a new table, but I
can't figure out how to use a variable in the name of the new table
9
psql:rgio.sql:16: LINE 6: FOR lv IN SELECT DISTINCT rg FROM ldevrg LOOP
psql:rgio.sql:16:
^
Ideas?
____
From: [EMAIL PROTECTED] on behalf of Kevin Nikiforuk
Sent: Thu 7/20/2006 7:46
Sorry if this is in the archives, but I've done a search and couldn't find
anything relevant. I'm running HP's precompiled version of 8.1.3.1 as part of
their Internet Express offering, and I can't seem to run a for loop. Here's
what I'm seeing:
xp512-0715-0716=# FOR LV in 1..10 LOOP
xp512-071
