Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
set_table_by_key [2013/08/08 19:23] admin [Description] |
set_table_by_key [2013/09/12 23:35] admin [Notes] |
||
---|---|---|---|
Line 8: | Line 8: | ||
^ Name ^ Type ^ Description ^ | ^ Name ^ Type ^ Description ^ | ||
- | | Table | [[Table Type|Table]] | The input table. | + | | Table | [[Table Type|Table]] | The input table. | |
| Keys | [[Tuple Type|Tuple]] | Chain of keys identifying the sub-table that will be updated or insert. | | | Keys | [[Tuple Type|Tuple]] | Chain of keys identifying the sub-table that will be updated or insert. | | ||
- | | Sub Table | [[Table Type|Table]] | Sub-table that will be inserted in the input table. The column names in the sub-table must match the corresponding names in the input table. The column types must also be compatible. | | + | | Sub Table | [[Table Type|Table]] | Sub-table that will be inserted into the input table. The column names in the sub-table must match the corresponding names in the input table. The column types must also be compatible. | |
===== Outputs ===== | ===== Outputs ===== | ||
Line 23: | Line 23: | ||
===== Notes ===== | ===== Notes ===== | ||
- | This functor inserts elements corresponding to the given tuple of keys in the input table. | + | This functor inserts elements corresponding to the given tuple of keys into the input table. |
**Example 1:** | **Example 1:** | ||
Line 67: | Line 67: | ||
|@lightgreen: 2 |@green: "d" |@green: 22 |@green: 12 |@green: "dddd" |@green: 12 | | |@lightgreen: 2 |@green: "d" |@green: 22 |@green: 12 |@green: "dddd" |@green: 12 | | ||
- | If there is already a sub-table corresponding to the sub-table being inserted in the sub-table, the existent sub-table is replaced by the new sub-table. The same is true if the sub-table being inserted is empty. In this case, the existent sub-table is removed from the input table. | + | If there is already a sub-table corresponding to the sub-table being inserted in the table, the existent sub-table is replaced by the new sub-table. The same is true if the sub-table being inserted is empty. In this case, the existent sub-table is removed from the input table. |
- | It is not possible to insert a sub-table indexed by keys from arbitrary key columns. For example, in the example above, it is not possible to insert a sub-table corresponding to keys ''<2, 22>'', where 2 corresponds to the first column ("Key1") and 22 corresponds to the third column ("Key3"). To do this, first reorder the key columns using the [[Reorder Table Columns]] functor. | + | It is not possible to insert a sub-table indexed by keys from arbitrary key columns. For example, in the example above, it is not possible to insert a sub-table corresponding to keys ''<2, 22>'', where 2 corresponds to the first column ("Key1") and 22 corresponds to the third column ("Key3"). To do this, first reorder the key columns using the [[Reorder Table Column]] functor. |
===== Internal Name ===== | ===== Internal Name ===== |