Project

General

Profile

Statistics
| Revision:

root @ 14272

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 14272 over 10 years Aaron Marcuse-Kubitza bugfix: schemas/util.sql: check_constraint_expr...
  • svn:ignore: extern

Latest revisions

# Date Author Comment
14272 07/21/2014 03:24 PM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: check_constraint_expr_enable(): don't remove suffix without also removing prefix. this is done by using extract_by_regexp() instead. also changed check_constraint_enabled() to use regexps to match this.
14271 07/21/2014 03:08 PM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: extract_by_regexp(): needs surrounding COALESCE in case no match
14270 07/21/2014 03:05 PM Aaron Marcuse-Kubitza

schemas/util.sql: added extract_by_regexp()
14269 07/21/2014 09:02 AM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: added derived column _matched_has_accepted
14268 07/21/2014 08:47 AM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: added new derived columns to derived views
14267 07/21/2014 08:44 AM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: added derived columns "[matched_]scientificName[_with_author]__@DwC__@vegpath.org", "[accepted_]scientificName[_with_author]__@DwC__@vegpath.org"
14266 07/21/2014 08:29 AM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: added derived columns "[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org", "[accepted_]infraspecificEpithet__@DwC__@vegpath.org"
14265 07/21/2014 08:26 AM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: added derived column "__accepted_infraspecific_{rank,epithet}"
14264 07/21/2014 08:19 AM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: added derived column __accepted_infraspecific_label
14263 07/21/2014 08:12 AM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: canon_sql(): need to use the right search_path

View all revisions | View revisions

Also available in: Atom