Record unassigned yet - Mailing list pgsql-hackers

From Johann Robette
Subject Record unassigned yet
Date
Msg-id 005801c4a798$7ce9c820$a5010a0a@Johann
Whole thread Raw
Responses Re: Record unassigned yet
Re: Record unassigned yet
List pgsql-hackers
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?




pgsql-hackers by date:

Previous
From: "Matthew T. O'Connor"
Date:
Subject: Re: CREATE INDEX speeds up query on 31 row table ...
Next
From: Russell Smith
Date:
Subject: Re: Record unassigned yet