Received: from nmho05u.rohmhaas.com (firewall-user@nmho05u.rohmhaas.com [136.141.2.7]) by hub.org (8.8.8/8.7.5) with ESMTP id JAA22375 for ; Fri, 21 Aug 1998 09:53:33 -0400 (EDT) Received: by nmho05u.rohmhaas.com; id KAA15555; Fri, 21 Aug 1998 10:04:31 -0400 (EDT) Received: from ima1.ho.rohmhaas.com(136.141.37.145) by nmho05u.rohmhaas.com via smap (V3.1.1) id xma015497; Fri, 21 Aug 98 10:03:59 -0400 Received: from ccMail by ima1.rohmhaas.com (IMA Internet Exchange 3.01 Enterprise) id 00037989; Fri, 21 Aug 98 09:53:00 -0400 Mime-Version: 1.0 Date: Fri, 21 Aug 1998 08:38:53 -0400 Message-ID: <00037989.CE21284@RohmHaas.Com> From: Chauncey_Thorn@RohmHaas.Com (Chauncey Thorn) Subject: SQL statement Problem To: pgsql-sql@postgresql.org Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Description: cc:Mail note part 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