Re: parse error when executing a simple plpgsql function

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Louis Foucart <lfoucart(at)dcc(dot)uchile(dot)cl>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: parse error when executing a simple plpgsql function
Date: 2003-05-21 14:32:07
Message-ID: 6996.1053527527@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Louis Foucart <lfoucart(at)dcc(dot)uchile(dot)cl> writes:
> for r in select father_id, denom, abbrev from data_columns
> return next r;
> end loop;

I think you need a "loop" in there.

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2003-05-21 14:43:52 Re: postmaster didnt start after power failure.
Previous Message Nabil Sayegh 2003-05-21 11:04:35 Re: connect by [prior]