GET

GET
Prev	Chapter 43. GDBase Command Reference	Next

The GET command is a variant of SELECT. Its syntax and behavior mimic that of SELECT with the exception of the following differences:

With GET any new column defined by an expression can be explicitly used in the definition of subsequent columns.
GET supports reusing of column names: If a more than one column is named with the same result-column-name in the result list of GET, only the last instance will be accpeted for further processing. As the elements of the result list are processed from left to right, when a result-column-name is used in an expression defining a subseqent column, the most recent value assigned to result-column-name will be used in the evaluation of the expression.

Example 43.13. The GET command

table 'table_1':
    a b c
    1 1 1
    1 1 2
    1 2 3
    2 1 1
    2 1 2
    2 2 3


sql table_2:
    GET *, a+b AS d, d*c, d*c AS e, -1 AS e FROM table_1

print table_2

Output:

a | b | c | d | d*c | e  | 
+-+---+---+---+-----+----+--
1 | 1 | 1 | 2 |   2 | -1 | 
1 | 1 | 2 | 2 |   4 | -1 | 
1 | 2 | 3 | 3 |   9 | -1 | 
2 | 1 | 1 | 3 |   3 | -1 | 
2 | 1 | 2 | 3 |   6 | -1 | 
2 | 2 | 3 | 4 |  12 | -1 |

Prev	Up	Next
DROP VIEW	Home	INSERT