Record unassigned yet

From: "Johann Robette" <jrobette(at)onyme(dot)com>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Record unassigned yet
Date: 2004-10-01 09:24:39
Message-ID: 005801c4a798$7ce9c820$a5010a0a@Johann
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-jdbc

Hello,

I'm experiencing a strange problem. Here it is :
I've created a function with a FOR loop.

DECLARE
Current RECORD;
BEGIN
FOR current IN SELECT * FROM employees LOOP
Tmp := current.id;
END LOOP;
...

When I call the function, I get the error :
ERROR: record " current " is unassigned yet

Any idea?

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Russell Smith 2004-10-01 11:19:51 Re: Record unassigned yet
Previous Message Oliver Jowett 2004-10-01 07:36:20 Re: RE : Remote query very slow

Browse pgsql-jdbc by date

  From Date Subject
Next Message Russell Smith 2004-10-01 11:19:51 Re: Record unassigned yet
Previous Message Oliver Jowett 2004-10-01 07:36:20 Re: RE : Remote query very slow