[POSTGRES] Rzutowanie typów XML - > NUMERIC

insert into tariffs (id,name,value,period,taxid,uprate,downrate)

select a_users.user_id::text::int
,a_users.user_id
,(xpath ('//price//text()',a_users.products)) ::numeric

Niestety rzutowanie na ::numeric daje komuniakt :

Nie można rzutować xml na numeric. 

Pomoże ktoś ?

Z góry dzięki ...

select s3t_users.user_id::text::int
,s3t_users.user_id
,(xpath ('//price//text()',s3t_users.products))
,3
,1
,rate_in
,rate_out

from s3t_users inner join s3t_addresses ON s3t_users.user_id = s3t_addresses.user_id


INSERT INTO ""("user_id", "user_id", "xpath", "?column?", "?column?", "rate_in", "rate_out") VALUES (3849, 3849, '{}', 3, 1, 10590618, 1153434);
INSERT INTO ""("user_id", "user_id", "xpath", "?column?", "?column?", "rate_in", "rate_out") VALUES (4880, 4880, '{}', 3, 1, 10485760, 2097152);
INSERT INTO ""("user_id", "user_id", "xpath", "?column?", "?column?", "rate_in", "rate_out") VALUES (4880, 4880, '{}', 3, 1, 10485760, 2097152);
INSERT INTO ""("user_id", "user_id", "xpath", "?column?", "?column?", "rate_in", "rate_out") VALUES (2290, 2290, '{}', 3, 1, 2202009.6, 307200);
INSERT INTO ""("user_id", "user_id", "xpath", "?column?", "?column?", "rate_in", "rate_out") VALUES (1921, 1921, '{55}', 3, 1, 12687770, 2202010);