dustov <dustov@xxxxxxxxx> writes: > PGError: ERROR: input is out of range I see no such error string in the current sources ... what Postgres version are you using? If you set "\set VERBOSITY verbose" in psql before trying the query, you should get some extra info about where the message is coming from. regards, tom lane ---------------------------(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