Received: from lists.unixathome.org (lists.unixathome.org [210.48.103.158]) by postgresql.org (Postfix) with ESMTP id EB20647545D for ; Mon, 25 Feb 2002 18:52:53 -0500 (EST) Received: from wocker (lists.unixathome.org [210.48.103.158]) by lists.unixathome.org (8.11.6/8.11.6) with ESMTP id g1PNqkk69902; Tue, 26 Feb 2002 12:52:47 +1300 (NZDT) (envelope-from dan@lists.unixathome.org) Message-Id: <200202252352.g1PNqkk69902@lists.unixathome.org> From: "Dan Langille" Organization: DVL Software Limited To: Tom Lane Date: Mon, 25 Feb 2002 18:52:39 -0500 MIME-Version: 1.0 Subject: Re: record iteration within SQL Reply-To: dan@langille.org Cc: pgsql-sql@postgresql.org References: <200202252208.g1PM8wk69093@lists.unixathome.org> In-reply-to: <25516.1014680718@sss.pgh.pa.us> X-mailer: Pegasus Mail for Windows (v4.01) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body X-Archive-Number: 200202/374 X-Sequence-Number: 6796 On 25 Feb 2002 at 18:45, Tom Lane wrote: > "Dan Langille" writes: > > I don't under stand why I get this error: > > > ERROR: record stagingport has no field name > > Would it help any if the error message used some quotes? > > ERROR: record "stagingport" has no field "name" > > ie, there's no column named "name" in SELECT * FROM watch_list_staging ... Yes Tom, it would. That makes much more sense now. Thank you. -- Dan Langille The FreeBSD Diary - http://freebsddiary.org/ - practical examples