Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id A93B09FBAE4 for ; Thu, 12 Apr 2007 09:15:56 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 65006-03-6 for ; Thu, 12 Apr 2007 09:15:47 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from interscan.indicator.com (mail.indicator.be [193.121.199.3]) by postgresql.org (Postfix) with ESMTP id 43CE69FBAB4 for ; Thu, 12 Apr 2007 09:15:44 -0300 (ADT) Received: from webaccess.indicator.be ([10.100.1.7]) by interscan.indicator.com with InterScan Message Security Suite; Thu, 12 Apr 2007 14:02:11 +0200 Received: from DOMEXT-MTA by webaccess.indicator.bewith Novell_GroupWise; Thu, 12 Apr 2007 14:15:41 +0200 Message-Id: <461E3EFE.A3DD.0030.0@indicator.be> X-Mailer: Novell GroupWise Internet Agent 7.0.1 Date: Thu, 12 Apr 2007 14:15:27 +0200 From: "Bart Degryse" To: Subject: Re: ERROR: column "crc" does not exist References: In-Reply-To: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=__PartDDFA88CF.0__=" X-imss-version: 2.046 X-imss-result: Passed X-imss-approveListMatch: *@indicator.be X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.052 tagged_above=0 required=5 tests=AWL=0.281, BAYES_20=-0.74, FORGED_RCVD_HELO=0.135, HTML_30_40=0.374, HTML_MESSAGE=0.001, UNPARSEABLE_RELAY=0.001 X-Spam-Level: X-Archive-Number: 200704/128 X-Sequence-Number: 28128 --=__PartDDFA88CF.0__= Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Try either - defining the field as: crc character varying(255) - rewrite your select as: Select * from base.points where "CRC" =3D = 'e19e26330a0db2f2435106b16623fa82'; >>> 2007-04-12 14:23 >>> 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 =3D '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 ( http://ezequiasrocha.blogspot.com/ ) ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match --=__PartDDFA88CF.0__= Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Content-Description: HTML

Try either

- defining the field as: crc character varying(255)

- rewrite your select as: Select * from base.points where "CRC" =3D = 'e19e26330a0db2f2435106b16623fa82';

>>> <ezequias@fastco= n.com.br> 2007-04-12 14:23 >>>
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 =3D 'e19e26330= a0db2f2435106b16623fa82'

The error on the Subject of this e-mail = allways appears.

Any help would be great.

Regards,
--
E= zequias Rodrigues da Rocha
http://ezequiasrocha.blogspot.com

------------------------= ---(end of broadcast)---------------------------
TIP 9: In versions = below 8.0, the planner will ignore your desire to
&nbs= p; choose an index scan if your joining column's datatypes do = not
match

--=__PartDDFA88CF.0__=--