From Bart.Degryse@indicator.be Thu Apr  12 12:15:56 2007
Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id A93B09FBAE4
	for <pgsql-sql-postgresql.org@postgresql.org>;
	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 <pgsql-sql-postgresql.org@postgresql.org>;
	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 <pgsql-sql@postgresql.org>; 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" <Bart.Degryse@indicator.be>
To: <pgsql-sql@postgresql.org>
Subject: Re: ERROR: column "crc" does not exist
References: <web-48692358@correio2.docasdoporto.com.br>
In-Reply-To: <web-48692358@correio2.docasdoporto.com.br>
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';

>>> <ezequias@fastcon.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 '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

<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-15=
">
<META content=3D"MSHTML 6.00.2800.1264" name=3DGENERATOR></HEAD>
<BODY style=3D"MARGIN: 4px 4px 1px; FONT: 10pt Tahoma">
<DIV>Try either</DIV>
<DIV>- defining the field as: crc character varying(255)</DIV>
<DIV>- rewrite your select as: Select * from base.points where "CRC" =3D =
'e19e26330a0db2f2435106b16623fa82';<BR><BR>&gt;&gt;&gt; &lt;ezequias@fastco=
n.com.br&gt; 2007-04-12 14:23 &gt;&gt;&gt;<BR>Hi list,<BR><BR>I have a =
table with many fields and the latest field is:<BR><BR>"CRC" character =
varying(255),<BR><BR>When I try to access the table with a select with a =
where clause like<BR><BR>Select * from base.points where crc =3D 'e19e26330=
a0db2f2435106b16623fa82'<BR><BR>The error on the Subject of this e-mail =
allways appears.<BR><BR>Any help would be great.<BR><BR>Regards,<BR>--<BR>E=
zequias Rodrigues da Rocha<BR><A href=3D"http://ezequiasrocha.blogspot.com/=
">http://ezequiasrocha.blogspot.com</A><BR><BR><BR>------------------------=
---(end of broadcast)---------------------------<BR>TIP 9: In versions =
below 8.0, the planner will ignore your desire to<BR>&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp; choose an index scan if your joining column's datatypes do =
not<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; match<BR></DIV></BODY></HTML>

--=__PartDDFA88CF.0__=--




From andreas.kretschmer@schollglas.com Thu Apr  12 12:19:10 2007
Received: from localhost (maia-2.hub.org [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id 0190B9FA15F
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 12 Apr 2007 09:19:10 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024)
	with ESMTP id 48660-03 for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 12 Apr 2007 09:19:00 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from moutng.kundenserver.de (moutng.kundenserver.de
	[212.227.126.183])
	by postgresql.org (Postfix) with ESMTP id 0D2A69FB548
	for <pgsql-sql@postgresql.org>; Thu, 12 Apr 2007 09:19:05 -0300 (ADT)
Received: from [194.25.154.138] (helo=webserv.wug.de)
	by mrelayeu.kundenserver.de (node=mrelayeu3) with ESMTP (Nemesis),
	id 0MKxQS-1HbyGT1p3K-0001Ja; Thu, 12 Apr 2007 14:19:02 +0200
Received: from kretschmer by webserv.wug.de with local (Exim 3.36 #1)
	id 1HbyGS-0001nz-00
	for pgsql-sql@postgresql.org; Thu, 12 Apr 2007 14:19:00 +0200
Date: Thu, 12 Apr 2007 14:19:00 +0200
From: "A. Kretschmer" <andreas.kretschmer@schollglas.com>
To: pgsql-sql@postgresql.org
Subject: Re: ERROR: column "crc" does not exist
Message-ID: <20070412121900.GD29820@a-kretschmer.de>
References: <web-48692358@correio2.docasdoporto.com.br>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <web-48692358@correio2.docasdoporto.com.br>
X-OS: Debian/GNU Linux - weil ich es mir Wert bin!
X-Message-Flag: "Windows" is not the answer. "Windows" is the question and the
	answer is "no"!
User-Agent: Mutt/1.5.9i
X-Provags-ID: V01U2FsdGVkX18y3XNTHBo3z6nNcEp43RVhbX6cWtKUBEjQRCf
	dwtobHWDJgqpxI6KFt3m7o+X9EiQ1Pr8X11I1U4Yqf6EXMD6Yn
	V1sdxZOzheF06Mr9k28nbkzJD3k0y/9
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200704/129
X-Sequence-Number: 28129

am  Thu, dem 12.04.2007, um  9:23:39 -0300 mailte ezequias@fastcon.com.br folgendes:
> Hi list,
> 
> I have a table with many fields and the latest field is:
> 
> "CRC" character varying(255),

You have created a field called "CRC", with upper-case.



> 
> When I try to access the table with a select with a where clause like
> 
> Select * from base.points where crc = 'e19e26330a0db2f2435106b16623fa82'

You searched for a field "crc", with lower-case. rewrite your query to :
... where "CRC" = 'e19e26330a0db2f2435106b16623fa82'


Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net



From gweaver@shaw.ca Thu Apr  12 12:20:01 2007
Received: from localhost (maia-5.hub.org [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id D7AD59FB9FB
	for <pgsql-sql-postgresql.org@postgresql.org>;
	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 <pgsql-sql-postgresql.org@postgresql.org>;
	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 <pgsql-sql@postgresql.org>; 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 <gweaver@shaw.ca>
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: <web-48692358@correio2.docasdoporto.com.br>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200704/130
X-Sequence-Number: 28130


 Original Message From: <ezequias@fastcon.com.br>

> 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





From ajs@crankycanuck.ca Thu Apr  12 12:21:54 2007
Received: from localhost (maia-2.hub.org [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id 1DD599FBA06
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 12 Apr 2007 09:21:54 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024)
	with ESMTP id 49361-02 for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 12 Apr 2007 09:21:46 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140])
	by postgresql.org (Postfix) with ESMTP id 708A09FB9B7
	for <pgsql-sql@postgresql.org>; Thu, 12 Apr 2007 09:21:51 -0300 (ADT)
Received: from 227-54-222-209.mycybernet.net ([209.222.54.227]
	helo=phlogiston.dydns.org)
	by main2.mycybernet.net with esmtp (Exim 4.62)
	(envelope-from <ajs@phlogiston.dyndns.org>) id 1HbyJC-00060c-6B
	for pgsql-sql@postgresql.org; Thu, 12 Apr 2007 08:21:50 -0400
Received: by phlogiston.dydns.org (Postfix, from userid 1000)
	id B673F4050; Thu, 12 Apr 2007 08:21:44 -0400 (EDT)
Date: Thu, 12 Apr 2007 08:21:44 -0400
From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-sql@postgresql.org
Subject: Re: ERROR: column "crc" does not exist
Message-ID: <20070412122144.GB24825@phlogiston.dyndns.org>
References: <web-48692358@correio2.docasdoporto.com.br>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <web-48692358@correio2.docasdoporto.com.br>
User-Agent: Mutt/1.5.9i
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200704/131
X-Sequence-Number: 28131

On Thu, Apr 12, 2007 at 09:23:39AM -0300, ezequias@fastcon.com.br wrote:
> 
> "CRC" character varying(255),
  ^^^^^

> Select * from base.points where crc = 'e19e26330a0db2f2435106b16623fa82'
                                  ^^^

"CRC" != crc.  You need to spell the column name correctly.  Or don't
quote the identifier when you create the table.

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
A certain description of men are for getting out of debt, yet are
against all taxes for raising money to pay it off.
		--Alexander Hamilton



From ezequias@fastcon.com.br Thu Apr  12 12:05:39 2007
Received: from localhost (maia-3.hub.org [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 0EFAE9FB70A
	for <pgsql-sql-postgresql.org@postgresql.org>;
	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 <pgsql-sql-postgresql.org@postgresql.org>;
	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 <pgsql-sql@postgresql.org>; 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: <ezequias@fastcon.com.br>
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: <web-48692358@correio2.docasdoporto.com.br>
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