Postgres Pro
Downloads
Home   >   mailing lists

Re: parse error when executing a simple plpgsql function - Mailing list pgsql-novice

From Tom Lane
Subject Re: parse error when executing a simple plpgsql function
Date
Msg-id 6996.1053527527@sss.pgh.pa.us
Whole thread Raw
In response to parse error when executing a simple plpgsql function  (Louis Foucart <lfoucart@dcc.uchile.cl>)
List pgsql-novice
Tree view 
Louis Foucart <lfoucart@dcc.uchile.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

pgsql-novice by date:

Previous
From: Nabil Sayegh
Date:
Subject: Re: connect by [prior]
Next
From: Tom Lane
Date:
Subject: Re: postmaster didnt start after power failure.