Thread: ERROR: column "crc" does not exist

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

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

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

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