Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f22DYcx08314 for ; Fri, 2 Mar 2001 08:34:38 -0500 (EST) (envelope-from pgsql-sql-owner@postgresql.org) Received: from mailin8.bigpond.com ([139.134.6.96]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f2120dx49327 for ; Wed, 28 Feb 2001 21:00:39 -0500 (EST) (envelope-from aa2@bigpond.net.au) Received: from bigpond.net.au ([139.134.4.50]) by mailin8.bigpond.com (Netscape Messaging Server 4.15) with SMTP id G9HXSS01.WJT for ; Thu, 1 Mar 2001 12:05:16 +1000 Received: from CPE-144-132-75-163.vic.bigpond.net.au ([144.132.75.163]) by mail8.bigpond.com (Claudes-Invulnerable-MailRouter V2.9c 17/4527078); 01 Mar 2001 12:00:37 Message-ID: <3A9DAD09.E1FBBA50@bigpond.net.au> Date: Thu, 01 Mar 2001 12:59:38 +1100 From: Justin Clift X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.2.17-21mdk i686) X-Accept-Language: en MIME-Version: 1.0 To: PostgreSQL SQL Mailing list Subject: Help needed -> ERROR: record arow has no field description Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200103/19 X-Sequence-Number: 1661 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 : arow record; BEGIN 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;