or am I doing it wrong? ams=# create index company_00001.traffic_ip on company_00001.traffic using btree ( ip_id ) ; ERROR: parser: parse error at or near "." at character 27
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match