From: | Matej Cepl <cepl(at)surfbest(dot)net> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Problems with join (no such attribute, but it exists) |
Date: | 2003-05-14 16:30:07 |
Message-ID: | slrnbc4rof.5q1.cepl@komensky.surfbest.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi,
I do probably something very silly, but I am total novice in SQL world
(and social scientist, so no CS professional), but I need PostgreSQL
back-end for Grass, so I thought I could try to do some light SELECTing.
Well, I stumbled pretty early:
grass=> \d tracts_towns2000
Table "tracts_towns2000"
Column | Type | Modifiers
-----------+-----------------------+-----------
COMPL_ID | character varying(18) | not null
COUNTY_ID | smallint | not null
TRACT_ID | integer | not null
TOWN_ID | smallint | not null
AREA_ID | smallint | not null
Primary key: tracts_towns2000_pkey
grass=> \d tracts2000
Table "tracts2000"
Column | Type | Modifiers
------------+---------+-----------
objectid | bigint |
area | real |
perimeter | real |
state | text |
county | text |
tract | text |
ct_id | text |
logrecno | text |
blk_count | integer |
total_pop | bigint |
samp_pop | bigint |
dry_pct | real |
dry_acres | real |
dry_sqmi | real |
dry_sqkm | real |
shape_area | text |
shape_len | text |
grass=> SELECT * FROM tracts_towns2000 conv, tracts2000 tr LIMIT 1;
COMPL_ID | COUNTY_ID | TRACT_ID | TOWN_ID | AREA_ID
| objectid | area | perimeter | state | county | tract
| ct_id | logrecno | blk_count | total_pop | samp_pop | dry_pct
| dry_acres | dry_sqmi | dry_sqkm | shape_area
| shape_len
14000US25017341100 | 17 | 341100
| 5 | 5 | 1 | 2.55159e+07 | 45288.6 | 25 | 001
| 010100 | 25001010100 | 0000856 | 137 | 3431 | 3431
| 0.9805 | 6181.92 | 9.659 | 25.017 | 2.55158949367e+007
4.52885899988e+004 |
(1 row)
grass=> SELECT conv.tract_id, tr.tract FROM tracts_towns2000 conv,
tracts2000 tr LIMIT 5;
ERROR: No such attribute or function 'tract_id'
Can anybody explain me, which stupidy I have commited?
Thanks,
Matej Cepl
--
Matej Cepl,
GPG Finger: 89EF 4BC6 288A BF43 1BAB 25C3 E09F EF25 D964 84AC
138 Highland Ave. #10, Somerville, Ma 02143, (617) 623-1488
From | Date | Subject | |
---|---|---|---|
Next Message | Chad Thompson | 2003-05-14 16:46:25 | Re: Limiting processor power on queries |
Previous Message | Tom Lane | 2003-05-14 16:16:18 | Re: Limiting processor power on queries |