Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id D7AD59FB9FB for ; Thu, 12 Apr 2007 09:20:01 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 43167-04 for ; Thu, 12 Apr 2007 09:19:52 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from pd7mo1no.prod.shaw.ca (idcmail-mo2no.cg.shawcable.net [64.59.134.9]) by postgresql.org (Postfix) with ESMTP id AD4139FB9CD for ; Thu, 12 Apr 2007 09:19:57 -0300 (ADT) Received: from pd5mr1no.prod.shaw.ca (pd5mr1no-svcs.prod.shaw.ca [10.0.144.212]) by l-daemon (Sun ONE Messaging Server 6.0 HotFix 1.01 (built Mar 15 2004)) with ESMTP id <0JGD001EQWX8IPA0@l-daemon> for pgsql-sql@postgresql.org; Thu, 12 Apr 2007 06:19:56 -0600 (MDT) Received: from pn7ml2no.prod.shaw.ca ([10.0.149.111]) by pd5mr1no.prod.shaw.ca (Sun Java System Messaging Server 6.2-7.05 (built Sep 5 2006)) with ESMTP id <0JGD000ZUWX8M2V0@pd5mr1no.prod.shaw.ca> for pgsql-sql@postgresql.org; Thu, 12 Apr 2007 06:19:56 -0600 (MDT) Received: from Dell4500 ([24.77.157.242]) by l-daemon (Sun ONE Messaging Server 6.0 HotFix 1.01 (built Mar 15 2004)) with SMTP id <0JGD002ZOWX2ZS00@l-daemon> for pgsql-sql@postgresql.org; Thu, 12 Apr 2007 06:19:56 -0600 (MDT) Date: Thu, 12 Apr 2007 07:21:23 -0500 From: George Weaver Subject: Re: ERROR: column "crc" does not exist To: pgsql-sql@postgresql.org Message-id: <002f01c77cfd$16bfd7f0$6400a8c0@Dell4500> MIME-version: 1.0 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 X-Mailer: Microsoft Outlook Express 6.00.2900.3028 Content-type: text/plain; format=flowed; charset=iso-8859-1; reply-type=response Content-transfer-encoding: 7bit X-Priority: 3 X-MSMail-priority: Normal References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/130 X-Sequence-Number: 28130 Original Message From: > I have a table with many fields and the latest field is: > > "CRC" character varying(255), ^^^^^^ > Select * from base.points where crc = 'e19e26330a0db2f2435106b16623fa82' What happens when you enter: Select * from base.points where "CRC" = 'e19e26330a0db2f2435106b16623fa82'; Regards, George