PostgreSQL Table Translation Framework v2.0.0
Major version number increase from 1.0.0 to 2.0.0 because some helper functions were dropped and hence translation tables written using these functions would have to be modified.
Tested with PostgreSQL v13.1 and v11.3
Main changes:
-
Queries prepared by TT_Prepare() now convert all explicit MatchTable(), LookupText(), LookupInt() and LookupDouble() helper functions found in translation tables to LEFT JOINs (#242, #243).
Implicit calls to those functions (embedded in existing helper functions) continue to work as inline subqueries and are not converted to LEFT JOINs. They should be slower than their converted equivalent.
All Table Translation Framework helper functions that used to call those functions have been removed. They are:
- TT_LookupTextMatchList()
- TT_MatchTableSubstring()
- TT_LookupTextSubstring()
- TT_AlphaNumericLookupTextMatchList()
- TT_AlphaNumericMatchTable()
- TT_IsLessThanLookupDouble()
- TT_MinIndexMatchTable()
- TT_GetIndexMatchTable()
- TT_MinIndexLookupText()
- TT_MaxIndexLookupText()
- TT_GetIndexLookupText()
Those helper functions will no longer work in existing translation tables and have to be replaced with their explicit lookup helper functions equivalent so that the translation engine can recognize them and convert them to LEFT JOINs:
Ex. 1. replace getIndexMatchTable() with matchTable(getIndexText())
Ex. 2. replace isLessThanLookupDouble() with isLessThan(x, lookupText())
You can have a look at the query prepared by TT_Prepare() in the message tab of the pgAdmin query tool.
-
Fixes to or new helper functions (#241)
-
General documentation review (#226)