provide zipcodes file for Mexico

Hi greggles. Your table is missing a few zipcodes =P. I do like the Viva México statement =).

Here is a table with more zipcodes. Data taken from http://www.geonames.org/

Hmmmmm. tried uploading the file but it is too big. Gzipped is 3MB. How can I add it to this issue?

Ok. I think I was using the wrong file. Gzipped it does fit. Unzipped it is 3 MB just like the US zipcodes file. And it does fit, maybe my connection was wrong and that's why it failed. Anyway.

here it is.

The multivalue insert allowed me to reduce the size of the file from 4MB to 3. And it is also how I see the current zipcodes.xx.mysql files are structured. Any specific reason why it should be one insert per row?

As for the Viva México, you are right!!! Totally forgot =)
added.

Ups! Now really added =P.

That's a good question. I looked into postgres, and seems like it is compatible http://www.postgresql.org/docs/8.2/interactive/sql-insert.html.

INSERT INTO films (code, title, did, date_prod, kind) VALUES
    ('B6717', 'Tampopo', 110, '1985-02-10', 'Comedy'),
    ('HG120', 'The Dinner Game', 140, DEFAULT, 'Comedy');

On the other hand, on sqlite it is not supported. http://www.sqlite.org/lang_insert.html =(.

postponed before tests fix
#1931088: [META] Fixing tests

tests fixed #1931088: [META] Fixing tests
lets go

Please. do provide a patch against latest dev for review

latest version tag

Updated issue summary.

Created patch file with zip codes for Mexico

thanks, commited

The patch by Yuriy Krysiuk contains zipcodes for australia not mexico.