Updates on postgres 8.3: Operator does not exist: integer = character varying

Dear all,

due to some changes in postgres 8.3 http://www.postgresql.org/docs/current/static/release-8-3.html typecasts are no longer automatically allowed.

e.g. integer=character varying is not allowed.

This caused a problem sometimes when using the configuring option on blocks.module.

here is my proposed patch.

302c302
<   return db_fetch_array(db_query("SELECT bx.*, bl.title FROM {boxes} bx INNER JOIN {blocks} bl ON bx.bid = bl.delta WHERE bl.module = 'block' AND bx.bid = %d", $bid));
---
>   return db_fetch_array(db_query("SELECT bx.*, bl.title FROM {boxes} bx INNER JOIN {blocks} bl ON bl.delta='%d' WHERE bl.module = 'block' AND bx.bid = %d", $bid,$bid));

note the '' on bl.delta since bl.delta is varchar and bid is an integer (from a sequence).

I hope i got it right...
cheers
alexie