Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
|
get_table_from_key [2015/10/12 00:30] admin |
get_table_from_key [2015/10/14 02:56] (current) admin |
||
|---|---|---|---|
| Line 40: | Line 40: | ||
| | 1 | "a" | 11 | 12 | "bbbb" | 23 | | | 1 | "a" | 11 | 12 | "bbbb" | 23 | | ||
| | 1 | "b" | 22 | 12 | "cccc" | 23 | | | 1 | "b" | 22 | 12 | "cccc" | 23 | | ||
| - | |@lightgreen: 2 |@lightgreen: "a" |@green: 11 |@green: 12 |@green: "bbbb" |@green: 14 | | + | |@#CCFFCC: 2 |@#CCFFCC: "a" |@#C5D9FF: 11 |@#C5D9FF: 12 |@#C5D9FF: "bbbb" |@#C5D9FF: 14 | |
| - | |@lightgreen: 2 |@lightgreen: "a" |@green: 22 |@green: 12 |@green: "aaaa" |@green: 23 | | + | |@#CCFFCC: 2 |@#CCFFCC: "a" |@#C5D9FF: 22 |@#C5D9FF: 12 |@#C5D9FF: "aaaa" |@#C5D9FF: 23 | |
| | 2 | "d" | 22 | 12 | "dddd" | 12 | | 2 | "d" | 22 | 12 | "dddd" | 12 | ||
| Line 47: | Line 47: | ||
| ^ Key3* ^ Value1 ^ Value2 ^ Value3 ^ | ^ Key3* ^ Value1 ^ Value2 ^ Value3 ^ | ||
| - | |@green: 11 |@green: 12 |@green: "bbbb" |@green: 14 | | + | |@#C5D9FF: 11 |@#C5D9FF: 12 |@#C5D9FF: "bbbb" |@#C5D9FF: 14 | |
| - | |@green: 22 |@green: 12 |@green: "aaaa" |@green: 23 | | + | |@#C5D9FF: 22 |@#C5D9FF: 12 |@#C5D9FF: "aaaa" |@#C5D9FF: 23 | |
| **Example 2:** | **Example 2:** | ||
| Line 57: | Line 57: | ||
| | 1 | "a" | 11 | 12 | "bbbb" | 23 | | | 1 | "a" | 11 | 12 | "bbbb" | 23 | | ||
| | 1 | "b" | 22 | 12 | "cccc" | 23 | | | 1 | "b" | 22 | 12 | "cccc" | 23 | | ||
| - | |@lightgreen: 2 |@green: "a" |@green: 11 |@green: 12 |@green: "bbbb" |@green: 14 | | + | |@#CCFFCC: 2 |@#C5D9FF: "a" |@#C5D9FF: 11 |@#C5D9FF: 12 |@#C5D9FF: "bbbb" |@#C5D9FF: 14 | |
| - | |@lightgreen: 2 |@green: "a" |@green: 22 |@green: 12 |@green: "aaaa" |@green: 23 | | + | |@#CCFFCC: 2 |@#C5D9FF: "a" |@#C5D9FF: 22 |@#C5D9FF: 12 |@#C5D9FF: "aaaa" |@#C5D9FF: 23 | |
| - | |@lightgreen: 2 |@green: "d" |@green: 22 |@green: 12 |@green: "dddd" |@green: 12 | | + | |@#CCFFCC: 2 |@#C5D9FF: "d" |@#C5D9FF: 22 |@#C5D9FF: 12 |@#C5D9FF: "dddd" |@#C5D9FF: 12 | |
| results in | results in | ||
| ^ Key2* ^ Key3* ^ Value1 ^ Value2 ^ Value3 ^ | ^ Key2* ^ Key3* ^ Value1 ^ Value2 ^ Value3 ^ | ||
| - | |@green: "a" |@green: 11 |@green: 12 |@green: "bbbb" |@green: 14 | | + | |@#C5D9FF: "a" |@#C5D9FF: 11 |@#C5D9FF: 12 |@#C5D9FF: "bbbb" |@#C5D9FF: 14 | |
| - | |@green: "a" |@green: 22 |@green: 12 |@green: "aaaa" |@green: 23 | | + | |@#C5D9FF: "a" |@#C5D9FF: 22 |@#C5D9FF: 12 |@#C5D9FF: "aaaa" |@#C5D9FF: 23 | |
| - | |@green: "d" |@green: 22 |@green: 12 |@green: "dddd" |@green: 12 | | + | |@#C5D9FF: "d" |@#C5D9FF: 22 |@#C5D9FF: 12 |@#C5D9FF: "dddd" |@#C5D9FF: 12 | |
| If the resulting sub-table does not have at least one column of keys or if the given tuple of keys is not present in the input table, an error is reported. | If the resulting sub-table does not have at least one column of keys or if the given tuple of keys is not present in the input table, an error is reported. | ||