Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: record iteration within SQL
Date
Msg-id 25516.1014680718@sss.pgh.pa.us
Whole thread Raw
In response to record iteration within SQL  ("Dan Langille" <dan@langille.org>)
Responses Re: record iteration within SQL  ("Dan Langille" <dan@langille.org>)
List pgsql-sql
Tree view 
"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
...
        regards, tom lane

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Sort problem
Next
From: "Dan Langille"
Date:
Subject: Re: record iteration within SQL