Revision 4050
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/functions.sql | ||
|---|---|---|
| 151 | 151 |
-- |
| 152 | 152 |
|
| 153 | 153 |
CREATE AGGREGATE join_strs(text, text) ( |
| 154 |
SFUNC = join_strs_transform_fold_empty,
|
|
| 154 |
SFUNC = join_strs_transform_preserve_empty,
|
|
| 155 | 155 |
STYPE = text |
| 156 | 156 |
); |
| 157 | 157 |
|
Also available in: Unified diff
schemas/functions.sql: join_strs() aggregate: Use join_strs_transform_preserve_empty() as an optimization because all our data has already had '' replaced with NULL by sql_io.cleanup_table() in csv2db. This will help speed up _merges now that they are performed on a large scale in the slowest datasource, SpeciesLink.