From: Bart Degryse <Bart.Degryse@indicator.be>
To: pgsql-sql@postgresql.org
Subject: Re: ERROR: column "crc" does not exist
Date: Thu, 12 Apr 2007 14:15:27 +0200
Message-ID: <461E3EFE.A3DD.0030.0@indicator.be> (raw)
In-Reply-To: <web-48692358@correio2.docasdoporto.com.br>
References: <web-48692358@correio2.docasdoporto.com.br>
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 ( 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: Bart.Degryse@indicator.be
Subject: Re: ERROR: column "crc" does not exist
In-Reply-To: <461E3EFE.A3DD.0030.0@indicator.be>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox