X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 55CCD474E42 for ; Tue, 6 May 2003 05:18:53 -0400 (EDT) Received: from shop.sme.sk (episoftware.casablanca.sk [217.11.230.150]) by postgresql.org (Postfix) with ESMTP id 73509475F1C for ; Tue, 6 May 2003 05:18:24 -0400 (EDT) Received: from [193.58.192.97] (helo=juice) by shop.sme.sk with esmtp (Exim 3.35 #1 (Debian)) id 19CyJn-0005Dm-00 for ; Tue, 06 May 2003 11:01:00 +0200 Received: from 192.168.1.25 ([192.168.1.25]) by juice for pgsql-sql@postgresql.org; Tue, 6 May 2003 11:18:31 +0200 Subject: Problem with Attribute. From: Rado Petrik To: PostgreSQL-mailinglist Content-Type: text/plain Organization: Message-Id: <1052212666.551.29.camel@caj> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.3 Date: 06 May 2003 11:17:47 +0200 Content-Transfer-Encoding: 7bit X-Spam-Status: No, hits=-12.1 required=5.0 tests=BAYES_10,USER_AGENT_XIMIAN autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/74 X-Sequence-Number: 13239 Hi , I have table picture_path. 1. Step one. Write query to psql. power2=# select * from picture_path ; retur: id_path | p_path | count ---------+--------+-------- (0 rows) 2. Step two. Write query. power2=# select count from picture_path; return: ERROR: Attribute 'count' not found power2=# Why ? This is dump table picture_path. CREATE TABLE "picture_path" ( "id_path" int4 DEFAULT nextval('"picture_path_id_path_seq"'::text) NOT NULL, "p_path" varchar(20) NOT NULL, "count " int2 NOT NULL ); Thanks. - Rado Petrik