Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  FIA 12058 almost 11 years Aaron Marcuse-Kubitza added validation/aggregating/plots/FIA/bien3_va...
  SALVIAS 12404 almost 11 years Aaron Marcuse-Kubitza fix: validation/aggregating/plots/SALVIAS/bien3...
  _archive 12061 almost 11 years Aaron Marcuse-Kubitza validation/**: removed by=... indicators so tha...
bien3_validations_salvias_vegbien.sql 14.8 KB 12610 almost 11 years Aaron Marcuse-Kubitza validation/aggregating/plots/bien3_validations_...

Latest revisions

# Date Author Comment
12610 03/06/2014 11:03 AM Aaron Marcuse-Kubitza

validation/aggregating/plots/bien3_validations_salvias_vegbien.sql: search_path: removed public_validations since we are not creating views

12609 03/06/2014 11:02 AM Aaron Marcuse-Kubitza

validation/aggregating/plots/bien3_validations_salvias_vegbien.sql: use psql var :datasource instead of current_schema() so that the queries are runnable without special configuration of the search_path

12608 03/06/2014 10:59 AM Aaron Marcuse-Kubitza

validation/aggregating/plots/bien3_validations_salvias_vegbien.sql: removed `CREATE OR REPLACE VIEW` so the validations views are not unintentionally replaced when running this file

12607 03/06/2014 10:57 AM Aaron Marcuse-Kubitza

validation/aggregating/plots/bien3_validations_salvias_vegbien.sql: updated from DB

12516 02/27/2014 01:27 PM Aaron Marcuse-Kubitza

bugfix: *.sql: public.source_by_shortname(): need to wrap it in a nested SELECT because Postgres incorrectly does not constant-fold (inline) it, leading to a slowdown when it is therefore run many times. this is done using the steps at wiki.vegpath.org/Postgres_queries#wrap-function-call-in-nested-SELECT .

12404 02/24/2014 08:37 AM Aaron Marcuse-Kubitza

fix: validation/aggregating/plots/SALVIAS/bien3_validations_salvias_db_original.VegCore.sql: renamed truncated views to match the output queries

12403 02/24/2014 12:30 AM Aaron Marcuse-Kubitza

bugfix: validation/aggregating/plots/SALVIAS/bien3_validations_salvias_db_original.VegCore.sql: can't double-JOIN like in MySQL (`JOIN a JOIN b ON a_conds AND b_conds`), so split double-JOIN into two JOINs w/ own ON clauses

12402 02/24/2014 12:28 AM Aaron Marcuse-Kubitza

validation/aggregating/plots/SALVIAS/bien3_validations_salvias_db_original.VegCore.sql: removed `LIMIT 10` to match output queries

12401 02/24/2014 12:26 AM Aaron Marcuse-Kubitza

fix: validation/aggregating/plots/SALVIAS/bien3_validations_salvias_db_original.VegCore.sql: updated table names to match our renamings

12398 02/24/2014 12:21 AM Aaron Marcuse-Kubitza

bugfix: validation/aggregating/plots/SALVIAS/bien3_validations_salvias_db_original.VegCore.sql: can't double-JOIN like in MySQL (`JOIN a JOIN b ON a_conds AND b_conds`), so split double-JOIN into two JOINs w/ own ON clauses

View revisions

Also available in: Atom