"Marcos Iuato" <iuato@samurai.com.br> writes: > Declare > mycars varchar[]; > car varchar; > Begin > For car in SELECT cars from table1 LOOP I think the iteration variable for a FOR ... IN SELECT has to be a record or rowtype variable. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org