Re: record iteration within SQL

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

On 25 Feb 2002 at 18:45, Tom Lane wrote:

> "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 ...

Yes Tom, it would. That makes much more sense now. Thank you.
--
Dan Langille
The FreeBSD Diary - http://freebsddiary.org/ - practical examples

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2002-02-26 04:10:29 Timestamp operator error
Previous Message Tom Lane 2002-02-25 23:45:18 Re: record iteration within SQL