Re: Please help, can't figure out what's wrong with this function... - Mailing list pgsql-sql

On Sep 12, 2005, at 8:14 AM, Moritz Bayer wrote:

> I get the following error:
> ERROR:  missing .. at end of SQL expression

it looks like your for loop is being interpreted as the integer  
variant, e.g. for i in 1..10 loop


> CREATE TYPE "public"."ty_stadtlandflussentry" AS (

> DECLARE objReturn ty_stadtlandflussentry;


Maybe it needs to be:

declare objReturn "public"."ty_stadtlandflussentry"%rowtype;



John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL