Re: ERROR: column "crc" does not exist

Try either
- defining the field as: crc character varying(255)
- rewrite your select as: Select * from base.points where "CRC" = 'e19e26330a0db2f2435106b16623fa82';

>>> <ezequias(at)fastcon(dot)com(dot)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 = '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