| From: | Chauncey_Thorn(at)RohmHaas(dot)Com (Chauncey Thorn) |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | SQL statement Problem |
| Date: | 1998-08-21 12:38:53 |
| Message-ID: | 00037989.CE21284@RohmHaas.Com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Can someone tell me why I can execute this SQL statement:
apps>select * from tbl_rdevices
apps>\g
and get results, but when I execute
------
apps=> select * from tbl_rdevices
apps-> where asset = '05227'
apps-> \g
ERROR: attribute 'asset' not found
apps=>
------
apps=> select asset, equipmentnumber
apps-> from tbl_rdevices
apps-> \g
ERROR: attribute 'asset' not found
apps=>
-----
the attribute 'asset' not found means?
Could some Please let me know what I'm doing wrong.
Using RedHat 5.1
postgresql-6.3.2-4
Chauncey THorn
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fred C. Richards | 1998-08-21 16:26:18 | Implementing transactions (reference) |
| Previous Message | Holger Mitterwald | 1998-08-21 07:30:07 | Re: [SQL] CHECK and IN (Sets in general) - What's the story? |