X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 80EEF476479 for ; Tue, 6 May 2003 05:55:10 -0400 (EDT) Received: from ns.cnlo.ro (cnlo.ro [193.231.112.154]) by postgresql.org (Postfix) with ESMTP id 3AC6E476262 for ; Tue, 6 May 2003 05:55:05 -0400 (EDT) Received: from cnlo.ro (marian.cnlo.ro [192.168.10.64]) by ns.cnlo.ro (8.12.8/8.12.8) with ESMTP id h469lftg031181; Tue, 6 May 2003 12:47:58 +0300 Message-ID: <3EB7857D.1070600@cnlo.ro> Date: Tue, 06 May 2003 12:50:53 +0300 From: Popeanga Marian User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.1) Gecko/20020823 Netscape/7.0 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Rado Petrik Cc: PostgreSQL-mailinglist Subject: Re: Problem with Attribute. References: <1052212666.551.29.camel@caj> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-RAVMilter-Version: 8.4.1(snapshot 20020919) (ns.cnlo.ro) X-Spam-Status: No, hits=-35.6 required=5.0 tests=BAYES_01,EMAIL_ATTRIBUTION,QUOTED_EMAIL_TEXT,REFERENCES, REPLY_WITH_QUOTES,USER_AGENT_MOZILLA_UA 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/76 X-Sequence-Number: 13241 \d picture_path in pgsql what returns ? Rado Petrik wrote: >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 > > >---------------------------(end of broadcast)--------------------------- >TIP 3: if posting/reading through Usenet, please send an appropriate >subscribe-nomail command to majordomo@postgresql.org so that your >message can get through to the mailing list cleanly > > > -- Popeanga Marian DBA Oracle CNLO Romania