In-Reply-To: <1364.62.66.218.59.1169073199.squirrel@mail.agile.dk>
References: <1364.62.66.218.59.1169073199.squirrel@mail.agile.dk>
Mime-Version: 1.0 (Apple Message framework v752.3)
Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed
Message-Id: <2AFADCD2-C72D-40FB-8B8E-D6FD023F2148@pgedit.com>
Cc: pgsql-sql@postgresql.org
Content-Transfer-Encoding: 7bit
From: John DeSoi <desoi@pgedit.com>
Subject: Re: Some help with functions-syntax
Date: Wed, 17 Jan 2007 19:50:40 -0500
To: Jan Meyland Andersen <jma@agile.dk>

Take a look at the documentation and examples again:

http://www.postgresql.org/docs/8.2/interactive/plpgsql-control- 
structures.html#PLPGSQL-RECORDS-ITERATING

There are two forms to iterate over the query:

1. FOR target IN query LOOP
2. FOR target IN EXECUTE text_expression LOOP

In your code you have mixed the two together. You appear to be trying  
to concatenate a string on to the end of a query expression. My  
suggestion is to eliminate the string you created (_WHERECLAUSE) and  
add the proper conditions to the query expression you already have.


On Jan 17, 2007, at 5:33 PM, Jan Meyland Andersen wrote:

> I have some problem with writing a function.
>
> I have made this function which I can't get it to work.
>
> This is probaly a triviel question but i'm new to plsql, so this is a
> showstopper for me.


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