Help needed -> ERROR: record arow has no field description

Hi all,

I'm getting this error, which to me makes no sense. Running PostgreSQL
7.0.3 on Mandrake 7.2 (compiled from source, not the rpms).

The code is in a pl/pgsql function I am writing and I can't see why it's
complaining.

This is the appropriate part of the code :

<general CREATE type header>

arow record;

<other declarations>

BEGIN

<other code here, which works>

FOR arow IN select transaction_payments.cashback from
transaction_payments, payment_types where
transaction_payments.payment_type = payment_types.idnum LOOP
textbuf := text(arow.cashback);
textbuf := textcat(textbuf, '' '');
insert into receipts (receipt_num, data) values (trans_num,
textbuf);
END LOOP;

<general END type syntax>

From the PostgreSQL log file (debug is set to 2), I am getting :

query: SELECT transaction_payments.cashback from transaction_payments,
payment_types where transaction_payments.payment_type =
payment_types.idnum
ERROR: record arow has no field description
DEBUG: Last error occured while executing PL/pgSQL function
create_receiptp3
DEBUG: line 105 at assignment
AbortCurrentTransaction

The "arow" record type variable is used quite a lot in previous FOR
loops in this function. This is the first FOR loop in the function that
uses more than one table though. I suspect this may have something to
do with it.

As far as I can tell, this SQL statement is valid. Does anyone have any
ideas how to get this to work. I have tried several variations, and the
mailing lists don't even have a reference for this error message.

Regards and best wishes,

Justin Clift
Database Administrator