Returns the value of a column identified by an index.
getmoneycolumnbyindex ( name, colindex, scale )
name | The name of a stream or window. |
colname | Integer corresponding to an index value of a column. Index is 0 based. |
scale | An integer between 1 and 15. |
Returns the value of a column identified by an index. The function takes a string for the name and integers for the colindex and scale arguments. The function returns a money type with the specified scale.
If colname argument evaluates to NULL or the specified column does not exist in the associated window or stream, the function returns NULL and generates an error message.
CREATE MEMORY STORE "memstore"; CREATE INPUT WINDOW iwin1 SCHEMA (a money(1), b money(3)) PRIMARY KEY (a) MEMORY STORE "memstore";
If you assume that the input passed into iwin1 was (1.2, 1.23), then getmoneycolumnbyindex ( iwin1, 1, 3 ) would return 1.123.