Re: Record unassigned yet - Mailing list pgsql-hackers

From Russell Smith
Subject Re: Record unassigned yet
Date
Msg-id 200410012119.51996.mr-russ@pws.com.au
Whole thread Raw
In response to Record unassigned yet  ("Johann Robette" <jrobette@onyme.com>)
Responses RE : Record unassigned yet
List pgsql-hackers
On Fri, 1 Oct 2004 07:24 pm, Johann Robette wrote:
> 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;
> ...
current != Current ?

> 
> When I call the function, I get the error :
>  ERROR:  record " current " is unassigned yet
> 
> Any idea?
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faqs/FAQ.html
> 
> 


pgsql-hackers by date:

Previous
From: "Johann Robette"
Date:
Subject: Record unassigned yet
Next
From: "Johann Robette"
Date:
Subject: RE : Record unassigned yet