Re: [GENERAL] error: insert has more expressions than target column

2004-09-10 Thread Björn Lundin
Dino Vliet wrote: > MUCH better nowI 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

Re: [GENERAL] error: insert has more expressions than target column

2004-09-07 Thread Dino Vliet
MUCH better nowI 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() R

Re: [GENERAL] error: insert has more expressions than target column

2004-09-07 Thread Tom Lane
Dino Vliet <[EMAIL PROTECTED]> writes: > I'm getting the same error without brackets. The message says you are trying to insert more values than the "lessons" table has columns. regards, tom lane ---(end of broadcast)--- TIP