[Qgis-user] PostGIS layer query issue

[Allar Haav]

Hi all,

I am experiencing a weird nuisance with PostGIS layers. Namely, the 
primary key of the table is of integer type. However, when selecting 
features via expression or setting rule-specific styles using this ID 
field, it seems that the integers are not treated as properly numeric. 
For example, a query of "id" >= 2 shows all features with ID starting 
with 2 or bigger number. It does not find features with ID of 10000 for 
example. Therefore I have to use toint("id") >= 2, but I have a strange 
feeling that this workaround is not really a solution. Oddly enough, an 
SQL query with DB Manager plugin works fine. To make things even more 
weird, the layer "Filter" feature also seems to function properly.
I'm using QGIS 2.0.1 from OSGeo4W on Win 7 64-bit.
Any ideas?

Regards,
Allar