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 12285 almost 11 years Aaron Marcuse-Kubitza schemas/util.sql: added inherit()
  • svn:ignore: extern

Latest revisions

# Date Author Comment
12285 02/17/2014 01:54 PM Aaron Marcuse-Kubitza

schemas/util.sql: added inherit()

12284 02/17/2014 01:46 PM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: diff(): need to explicitly cast each side to the return type because this does not happen automatically even when an implicit cast is available

12283 02/17/2014 01:32 PM Aaron Marcuse-Kubitza

schemas/util.sql: renamed diff_views(), diff_any() to diff(...) because they are overloads of the same operation

12282 02/17/2014 01:22 PM Aaron Marcuse-Kubitza

schemas/util.sql: diff_any(): documented how to run EXPLAIN on the FULL JOIN query

12281 02/17/2014 01:19 PM Aaron Marcuse-Kubitza

schemas/util.sql: removed non-useful diff_queries() (it is not possible to match distinct `record` types to a common return type, so this would not have worked). use diff_views() instead.

12280 02/17/2014 01:14 PM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: diff_queries(), diff_views(): embed views verbatim as FROM items, so that the type of their corresponding columns is the view's rowtype. this is necessary in order to match the types of the columns to the return type (set by col_type_null).

12279 02/17/2014 12:52 PM Aaron Marcuse-Kubitza

schemas/util.sql: diff_cols(): renamed to diff_queries() because multiple columns are supported

12278 02/17/2014 12:26 PM Aaron Marcuse-Kubitza

fix: schemas/util.sql: diff_cols(): don't assume that each side will have one column, as many of our validations queries have multiple columns

12277 02/17/2014 11:45 AM Aaron Marcuse-Kubitza

bugfix: schemas/util.sql: diff_views(): need to use $2, not $1, for the 2nd query

12276 02/17/2014 11:40 AM Aaron Marcuse-Kubitza

fix: schemas/util.sql: materialize_query(): remove any extra blank line before the query, to improve readability when newlines are used as a log message separator and are therefore confusing in the middle of a log message

View all revisions | View revisions

Also available in: Atom