Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Iterating over an varchar array?
Date
Msg-id 26206.1085510869@sss.pgh.pa.us
Whole thread Raw
In response to Iterating over an varchar array?  ("Marcos Iuato" <iuato@samurai.com.br>)
List pgsql-general
Tree view 
"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

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: FW: Majordomo results: subscribe pgsql-general
Next
From: Wei Shi
Date:
Subject: About table schema