PostgreSQL: boolean + integer -

PostgreSQL: boolean + integer -

i have query like:

select (column 'string')+100

it returns error: operator not exist: boolean + integer

i couldn't find function convert bool int, there text int: to_number().

is there way resolve issue?

use conditional expressions, see http://www.postgresql.org/docs/9.2/static/functions-conditional.html

postgresql integer boolean type-conversion