diff options
Diffstat (limited to 'src/postprocess')
-rw-r--r-- | src/postprocess/merge_entries.c | 2 | ||||
-rw-r--r-- | src/postprocess/postgres.sql | 2 | ||||
-rw-r--r-- | src/postprocess/sort_plz.c | 3 |
3 files changed, 4 insertions, 3 deletions
diff --git a/src/postprocess/merge_entries.c b/src/postprocess/merge_entries.c index 1dd7d50..aed0aec 100644 --- a/src/postprocess/merge_entries.c +++ b/src/postprocess/merge_entries.c | |||
@@ -26,7 +26,7 @@ const char *g_year_map[] = { | |||
26 | "1992_Q2", "1995_Q0", "1996_Q0", "1996_Q1", "1997_Q1", "1997_Q3", "1998_Q1", "1998_Q3", "1999_Q1", "1999_Q3", "2000_Q1", "2000_Q3", "2001_Q1", "2001_Q2", "2001_Q3", "2001_Q4", "2002_Q1", | 26 | "1992_Q2", "1995_Q0", "1996_Q0", "1996_Q1", "1997_Q1", "1997_Q3", "1998_Q1", "1998_Q3", "1999_Q1", "1999_Q3", "2000_Q1", "2000_Q3", "2001_Q1", "2001_Q2", "2001_Q3", "2001_Q4", "2002_Q1", |
27 | "2002_Q3", "2003_Q1", "2003_Q3", "2004_Q1", "2004_Q3", "2005_Q1", "2005_Q3", "2006_Q1", "2006_Q3", "2007_Q1", "2007_Q3", "2008_Q1", "2008_Q3", "2009_Q1", "2009_Q3", "2010_Q1", "2010_Q3", | 27 | "2002_Q3", "2003_Q1", "2003_Q3", "2004_Q1", "2004_Q3", "2005_Q1", "2005_Q3", "2006_Q1", "2006_Q3", "2007_Q1", "2007_Q3", "2008_Q1", "2008_Q3", "2009_Q1", "2009_Q3", "2010_Q1", "2010_Q3", |
28 | "2011_Q1", "2011_Q3", "2012_Q1", "2012_Q3", "2013_Q1", "2013_Q3", "2014_Q1", "2014_Q3", "2015_Q1", "2015_Q3", "2016_Q1", "2016_Q3", "2017_Q1", "2017_Q3", "2018_Q1", "2018_Q3", "2019_Q1", | 28 | "2011_Q1", "2011_Q3", "2012_Q1", "2012_Q3", "2013_Q1", "2013_Q3", "2014_Q1", "2014_Q3", "2015_Q1", "2015_Q3", "2016_Q1", "2016_Q3", "2017_Q1", "2017_Q3", "2018_Q1", "2018_Q3", "2019_Q1", |
29 | 0 | 29 | "2019_Q3", "2020_Q1", "2020_Q3", "2021_Q1", "2021_Q3", "2022_Q1", "2022_Q3", "2023_Q1", "2023_Q3", "2024_Q1", "2024_Q3", "2025_Q1", NULL |
30 | }; | 30 | }; |
31 | 31 | ||
32 | static int year_to_offset(const char *year) { | 32 | static int year_to_offset(const char *year) { |
diff --git a/src/postprocess/postgres.sql b/src/postprocess/postgres.sql index 2d89d1c..3c891d4 100644 --- a/src/postprocess/postgres.sql +++ b/src/postprocess/postgres.sql | |||
@@ -74,7 +74,7 @@ CREATE INDEX idx_strasse ON table_strasse USING btree (value, telefonbuch | |||
74 | CREATE INDEX idx_hausnummer ON table_hausnummer USING btree (value, telefonbuch_id, offs); | 74 | CREATE INDEX idx_hausnummer ON table_hausnummer USING btree (value, telefonbuch_id, offs); |
75 | CREATE INDEX idx_zip ON table_zip USING btree (value, telefonbuch_id, offs); | 75 | CREATE INDEX idx_zip ON table_zip USING btree (value, telefonbuch_id, offs); |
76 | CREATE INDEX idx_ort ON table_ort USING btree (value, telefonbuch_id, offs); | 76 | CREATE INDEX idx_ort ON table_ort USING btree (value, telefonbuch_id, offs); |
77 | CREATE INDEX idx_verweise ON table_verweise USING btree (value, telefonbuch_id, offs); | 77 | CREATE INDEX idx_verweise ON table_verweise USING btree (value, telefonbuch_id, offs) WHERE LENGTH(value) < 256; |
78 | CREATE INDEX idx_vorwahl ON table_vorwahl USING btree (value, telefonbuch_id, offs); | 78 | CREATE INDEX idx_vorwahl ON table_vorwahl USING btree (value, telefonbuch_id, offs); |
79 | CREATE INDEX idx_rufnummer ON table_rufnummer USING btree (value, telefonbuch_id, offs); | 79 | CREATE INDEX idx_rufnummer ON table_rufnummer USING btree (value, telefonbuch_id, offs); |
80 | CREATE INDEX idx_web ON table_web USING btree (value, telefonbuch_id, offs); | 80 | CREATE INDEX idx_web ON table_web USING btree (value, telefonbuch_id, offs); |
diff --git a/src/postprocess/sort_plz.c b/src/postprocess/sort_plz.c index dc0b222..9c67ab7 100644 --- a/src/postprocess/sort_plz.c +++ b/src/postprocess/sort_plz.c | |||
@@ -13,6 +13,7 @@ | |||
13 | #include <stdlib.h> | 13 | #include <stdlib.h> |
14 | #include <stdio.h> | 14 | #include <stdio.h> |
15 | #include <string.h> | 15 | #include <string.h> |
16 | #include <stdint.h> | ||
16 | #include <errno.h> | 17 | #include <errno.h> |
17 | #include <unistd.h> | 18 | #include <unistd.h> |
18 | #include <err.h> | 19 | #include <err.h> |
@@ -84,7 +85,7 @@ int main(int argc, char **args) { | |||
84 | char *input = malloc(1024); | 85 | char *input = malloc(1024); |
85 | size_t input_size = 1024; | 86 | size_t input_size = 1024; |
86 | 87 | ||
87 | if (argc != 1) exit(1); | 88 | if (argc != 2) exit(1); |
88 | 89 | ||
89 | /* First open all input files */ | 90 | /* First open all input files */ |
90 | for (i=F_01; i<F_COUNT; ++i) { | 91 | for (i=F_01; i<F_COUNT; ++i) { |