Re: record iteration within SQL - Mailing list pgsql-sql

From Dan Langille
Subject Re: record iteration within SQL
Date
Msg-id 200202252352.g1PNqkk69902@lists.unixathome.org
Whole thread Raw
In response to Re: record iteration within SQL  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
On 25 Feb 2002 at 18:45, Tom Lane wrote:

> "Dan Langille" <dan@langille.org> 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



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: record iteration within SQL
Next
From: "Josh Berkus"
Date:
Subject: Timestamp operator error