Revision 5902
Added by Aaron Marcuse-Kubitza over 12 years ago
| lib/sql.py | ||
|---|---|---|
| 1474 | 1474 |
|
| 1475 | 1475 |
def distinct_table(db, table, distinct_on): |
| 1476 | 1476 |
'''Creates a copy of a temp table which is distinct on the given columns. |
| 1477 |
The old and new tables will both get an index on these columns, to |
|
| 1478 |
facilitate merge joins. |
|
| 1477 |
Adds an index on table's distinct_on columns, to facilitate merge joins. |
|
| 1479 | 1478 |
@param distinct_on If empty, creates a table with one row. This is useful if |
| 1480 | 1479 |
your distinct_on columns are all literal values. |
| 1481 | 1480 |
@return The new table. |
Also available in: Unified diff
sql.py: distinct_table(): Changed comment about distinct_on column index to include just the input table, so that the function does not guarantee a unique index on the output table's distinct_on columns