LOOP Functions - where to start?

Hi all,

Thanks for the help a week or two ago with matching the time fields. I
managed to move on from that issue at last which was pleasing. I'm now
struggling with LOOP functions though. I've been having a look around the
net for some gentle introductions to them but haven't found any good ones
yet - could someone point me towards them if they exist? I don't like the
ones in the manual much.

Once I've learnt how loops work, I want to try and do something like the
below (simplified). Wrote in pseudo-code for now as I'm not sure how of the
format to write it properly and get it working. Essentially I want to split
a line into a number of equally defined and evenly spaced points. I
discovered the st_line_interpolate_point function, but I need to put that
inside a loop and store each record that it generates into a new table.
_____________
j = 0.2
i = 0.2
WHILE i < '1'
LOOP
SELECT ST_Line_Interpolate_Point(line, j)
INTO new_record_in_new_table
j = i+j
END LOOP
____________

Thanks for the communitys help as always.

James