MUCH better now....I did manage to get an insert into
the table lessons with these adjustments...BUT now it
seems the FOR LOOP didn't work because I only get 1
record and expected that I would get 8 records due to
the i variabele.
What could be wrong?
My code is now:
CREATE FUNCTION vulalles() RETURNS trigger AS '
BEGIN
FOR i in 0..7 LOOP
INSERT INTO lessons (......)
SELECT dayofweek,startdate + (i*7), enddate +
(i*7),...;
RETURN NEW;
END LOOP;
END;
' LANGUAGE plpgsql;
--- Richard Huxton <dev@archonet.com> wrote:
> Dino Vliet wrote:
> > I'm getting the same error without brackets.
>
> Check the columns in table "lessons" matches the
> columns in your select.
>
> > The EXECUTE statement was because I read something
> > about executing dynamic content.
> >
> > I want to add 7 days to the date value of
> startdate
> > and want to repeat it every week. Because there
> are 8
> > weeks I choose to do that with the for loop going
> from
> > 0 to 7.
>
> Looking closer, I can see the problem. You're
> treating the column from
> the select as a variable (which it isn't).
>
> Try something like:
>
> INSERT INTO lessons (col_name1, col_name2, ...)
> SELECT dayofweek, startdate + (i*7), endate + (i*7),
> startime, ...
>
> --
> Richard Huxton
> Archonet Ltd
>
__________________________________
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail