Re: Please help, can't figure out what's wrong with this function...

From: John DeSoi <desoi(at)pgedit(dot)com>
To: moritz(dot)bayer(at)googlemail(dot)com
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Please help, can't figure out what's wrong with this function...
Date: 2005-09-12 12:46:49
Message-ID: 0892AC11-818F-4110-8EFC-93C8FC886EC2@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2005-09-12 14:18:42 Re: Please help, can't figure out what's wrong with this function...
Previous Message Moritz Bayer 2005-09-12 12:14:22 Please help, can't figure out what's wrong with this function...