| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Johann Robette" <jrobette(at)onyme(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Record unassigned yet |
| Date: | 2004-10-01 14:47:05 |
| Message-ID: | 9449.1096642025@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-jdbc |
"Johann Robette" <jrobette(at)onyme(dot)com> writes:
> 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?
What you showed us looks fine, therefore the problem is in something you
didn't show us.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Johann Robette | 2004-10-01 14:51:14 | RE : Record unassigned yet |
| Previous Message | Marc G. Fournier | 2004-10-01 13:09:40 | Re: CREATE INDEX speeds up query on 31 row table ... |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Johann Robette | 2004-10-01 14:51:14 | RE : Record unassigned yet |
| Previous Message | Richard Huxton | 2004-10-01 11:45:54 | Re: RE : Record unassigned yet |