From: John DeSoi <desoi@pgedit.com>
To: moritz.bayer@googlemail.com
Cc: pgsql-sql@postgresql.org
Subject: Re: Please help, can't figure out what's wrong with this function...
Date: Mon, 12 Sep 2005 08:46:49 -0400
Message-ID: <0892AC11-818F-4110-8EFC-93C8FC886EC2@pgedit.com> (raw)
In-Reply-To: <c244500b05091205145a641ec7@mail.gmail.com>
References: <c244500b05091205145a641ec7@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: desoi@pgedit.com, moritz.bayer@googlemail.com
Subject: Re: Please help, can't figure out what's wrong with this function...
In-Reply-To: <0892AC11-818F-4110-8EFC-93C8FC886EC2@pgedit.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox