Try either
- defining the field as: crc character varying(255)
- rewrite your select as: Select * from base.points where "CRC" = '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 = '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---------------------------(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