[SQL] Text cast problem

[Volkmar Herbst]

Dear all- 

I encountered the following problem:

 

select * from parcel where number = '255 ' 

gives me 1 row but 

 

select * from parcel where number = '255 ' ::text

does give me 0 rows. The cast removes the trailing empty character.

 

Why is that? Unfortunately the statements are generated (NPGSQL) and I can’t 
change the way they are generated. What can I do? Any suggestions highly 
welcomed!

 

Volkmar