Re: SELECT problem - Mailing list pgsql-general

From Karel Zak
Subject Re: SELECT problem
Date
Msg-id 20020621124656.B28346@zf.jcu.cz
Whole thread Raw
In response to SELECT problem  (David Goodenough <david.goodenough@btconnect.com>)
Responses Re: SELECT problem  (David Goodenough <david.goodenough@btconnect.com>)
List pgsql-general
On Fri, Jun 21, 2002 at 11:38:39AM +0100, David Goodenough wrote:

> landn=# select * from sites;
>  CUSTNAME | AREA | SITE | NAME | BUILDING | TOWN | COUNTY | POSTCODE |
> GRIDREF | LATITUDE | LONGITUDE
> ----------+------+------+------+----------+------+--------+----------+---------+----------+-----------
> (0 rows)
>
> landn=# select area from sites;
> ERROR:  Attribute 'area' not found
> landn=#

 select "AREA" from sites;

       Karel

--
 Karel Zak  <zakkr@zf.jcu.cz>
 http://home.zf.jcu.cz/~zakkr/

 C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz

pgsql-general by date:

Previous
From: David Goodenough
Date:
Subject: SELECT problem
Next
From: John Gray
Date:
Subject: Re: SELECT problem