Project

General

Profile

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

Latest revisions

# Date Author Comment
14280 07/21/2014 05:03 PM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: derived_col_expr_from_check_constraint(): need to handle strs with \n after IS DISTINCT FROM

14279 07/21/2014 04:34 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: put matched-taxon derived columns before accepted-taxon derived columns

14278 07/21/2014 04:25 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: taxon_match: added derived column "[matched_]species[_binomial]~(Accepted_)__@TNRS__@vegpath.org"

14277 07/21/2014 04:08 PM Aaron Marcuse-Kubitza

inputs/.TNRS/schema.sql: _matched_has_accepted: renamed to matched_has_accepted because the leading _ did not create vertical alignment anyway, due to different quoting syntaxes

14276 07/21/2014 04:05 PM Aaron Marcuse-Kubitza

schemas/util.sql: added derived_col_name_from_check_constraint()

14275 07/21/2014 03:48 PM Aaron Marcuse-Kubitza

schemas/util.sql: derived_col_update(): add steps to rename column

14274 07/21/2014 03:42 PM Aaron Marcuse-Kubitza

web/username_prefix.php: transposes: removed recommendation for vertical alignment because different quoting syntaxes, etc. make it difficult to have a consistent alignment anyway

14273 07/21/2014 03:34 PM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: derived_col_update(): don't set_comment() until CHECK constraint exists so that we can use its canon-ed formula

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

View all revisions | View revisions

Also available in: Atom