Project

General

Profile

Statistics
| Revision:

root @ 14130

Name Size Revision Age Author Comment
  branches 11969 almost 11 years Aaron Marcuse-Kubitza added standard svn dirs branches, tags, trunk
  tags 11969 almost 11 years Aaron Marcuse-Kubitza added standard svn dirs branches, tags, trunk
  trunk 14130 over 10 years Aaron Marcuse-Kubitza schemas/util.sql: cluster_once(): use util.clus...
  • svn:ignore: extern

Latest revisions

# Date Author Comment
14130 07/19/2014 02:26 AM Aaron Marcuse-Kubitza

schemas/util.sql: cluster_once(): use util.cluster()
14129 07/19/2014 02:24 AM Aaron Marcuse-Kubitza

schemas/util.sql: cluster_once(): documented that this runs cluster only once if called repeatedly
14128 07/19/2014 02:24 AM Aaron Marcuse-Kubitza

schemas/util.sql: added cluster(), which reclusters each time
14127 07/19/2014 02:10 AM Aaron Marcuse-Kubitza

schemas/util.sql: cluster_once(): use simpler `LANGUAGE sql` now that we're using util.eval() instead of EXECUTE
14126 07/19/2014 02:03 AM Aaron Marcuse-Kubitza

schemas/util.sql: cluster_once(): use util.eval() instead of EXECUTE to print the CLUSTER statement (if any) it's using
14125 07/18/2014 11:40 PM Aaron Marcuse-Kubitza

fix: inputs/.TNRS/schema.sql: taxon_match: cluster the table so the rows are always exported in the same order, even when an UPDATE statement is used to run triggers
14124 07/18/2014 11:28 PM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: cluster_once(): need to use just the name of the index, without the schema prefix
14123 07/18/2014 05:00 PM Aaron Marcuse-Kubitza

schemas/util.sql: cluster_once(): use simpler IS DISTINCT FROM instead of array !=
14122 07/18/2014 03:18 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: added _accepted{genus,specific_epithet} derived column, using the steps at wiki.vegpath.org/Postgres_queries#maintaining-derived-column-formulas-across-column-renames
14121 07/18/2014 02:01 AM Aaron Marcuse-Kubitza

web/username_prefix.php: remove padding used to visually separate elements: documented that this also removes a leading __ that indicates an internal field

View all revisions | View revisions

Also available in: Atom