parse_address doesn't correctly handle Canada provinces

[robe]

SELECT (each(hstore(p))).* FROM parse_address('1207 Douglas Street, Suite 202, Victoria, BC, Canada V8W2E7') As p;

— I'm using hstore cause there are too many fields to output horizontally. Outputs:

   key    |                    value
----------+----------------------------------------------
 num      | 1207
 zip      | V8W2E7
 city     | Canada
 state    |
 street   | Douglas Street, Suite 202, Victoria, BC
 country  | CA
 street2  |
 zipplus  |
 address1 | 1207 Douglas Street, Suite 202, Victoria, BC

Should BC be in State and Victoria the City

[robe]

I'll try to dsee if I can fix in 2.2, but may not be able to.