Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 0EFAE9FB70A for ; Thu, 12 Apr 2007 09:05:39 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 07158-06 for ; Thu, 12 Apr 2007 09:05:29 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from correio2.docasdoporto.com.br (22.144.199.200.docasdoporto.com.br [200.199.144.22]) by postgresql.org (Postfix) with ESMTP id 2588F9FB616 for ; Thu, 12 Apr 2007 09:05:33 -0300 (ADT) Received: from [201.32.176.97] (account ezequias@fastcon.com.br) by correio2.docasdoporto.com.br (CommuniGate Pro WebUser 4.1.8) with HTTP id 48692358 for pgsql-sql@postgresql.org; Thu, 12 Apr 2007 09:23:39 -0300 From: Subject: ERROR: column "crc" does not exist To: pgsql-sql@postgresql.org X-Mailer: CommuniGate Pro WebUser Interface v.4.1.8 Date: Thu, 12 Apr 2007 09:23:39 -0300 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1"; format="flowed" Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/127 X-Sequence-Number: 28127 Hi list, I have a table with many fields and the latest field is: "CRC" character varying(255), When I try to access the table with a select with a where clause like Select * from base.points where crc = 'e19e26330a0db2f2435106b16623fa82' The error on the Subject of this e-mail allways appears. Any help would be great. Regards, -- Ezequias Rodrigues da Rocha http://ezequiasrocha.blogspot.com