Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fBNGeBm68408 for ; Sun, 23 Dec 2001 11:40:12 -0500 (EST) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id fBNGNij09589 for pgsql-sql@postgresql.org; Sun, 23 Dec 2001 11:23:44 -0500 (EST) (envelope-from news) From: "Juan Riera" X-Newsgroups: comp.databases.postgresql.sql Subject: Re: PostgreSQL SELECT error Date: Sun, 23 Dec 2001 17:23:37 +0100 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 34 Message-ID: References: X-Complaints-To: news@hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 To: pgsql-sql@postgresql.org X-Archive-Number: 200112/245 X-Sequence-Number: 6067 It works - thanks, Lee However I don't understand what happened as I have created this table through W98/ODBC from Approach and I did not put explicitly any quotes on variables. Maybe Approach does it? Can I eliminate this quotes from column names and put names in small caps? Thanks, Juan "Lee Harr" escribió en el mensaje news:a03id3$1b4$1@news.tht.net... > > I am trying SELECT CDART FROM PREVIS > > where PREVIS is a table on my STOCKS database, and CDART is a data column. > > I get this error: > > > > Attribute 'cdart' not found > > > > but when I do SELECT * FROM PREVIS I get all my table OK including column > > CDART. > > > How about > > SELECT "CDART" FROM previs > ? > > Possibly you defined the table with quotes and all caps > (which would make the identifier case sensitive, I believe) >