Re: record iteration within SQL

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: dan(at)langille(dot)org
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: record iteration within SQL
Date: 2002-02-25 23:45:18
Message-ID: 25516.1014680718@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Dan Langille" <dan(at)langille(dot)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
...

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Dan Langille 2002-02-25 23:52:39 Re: record iteration within SQL
Previous Message Tom Lane 2002-02-25 23:09:21 Re: Sort problem