create or replace function to_dec(text)
returns integer as $$
declare r int;
begin
execute 'select x'''||coalesce($1,'''')||'''::integer' into r;
return r;
end
$$ language plpgsql;