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