Iterating over an varchar array? - Mailing list pgsql-general

From Marcos Iuato
Subject Iterating over an varchar array?
Date
Msg-id 2851.192.168.0.251.1085503344.squirrel@mail.samurai.com.br
Whole thread Raw
Responses Re: Iterating over an varchar array?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I am trying to iterate over an varchar array using plpgsql but i get the
this error:

Error: missing .. at the end of SQL expression

My Table:

TABLE1(
Cars VARCHAR[]
)

My Code

Declare
 mycars varchar[];
 car varchar;
Begin
 For car in SELECT cars from table1 LOOP
   RAISE Notice "CAR: %", car
 END Loop;
END;

Resume, i have a column with a list of varchar type and i would like to
iterate over this array, is this possible?

Thanks,

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: restore from a pg_dumpall file
Next
From: Peter Eisentraut
Date:
Subject: Re: Making a new tarball