2006.10.05Contents
1 Introduction
2 The Interactive Environment
2.1 Assignment (Specification)
2.2 Errors
2.3 End a Session
3 Atomic Datatypes
3.1 Temporal Fields
4 Atom Functions
4.1 Arithmetic Functions
4.2 Relational Functions
4.3 Comparison Functions
4.4 Logical Functions
4.5 Floor and Absolute Value
5 Match
6 Order of Evaluation
7 Arithmetic
7.1 Temporal Arithmetic
7.2 IEEE NaNs and Infinities
7.3 Integer Arithmetic
8 Relational Tables and Insert
8.1 Table Displays
8.2 The Kdb+ Web Viewer
9 Example Tables
10 Foreign Keys
10.1 Virtual Columns
11 Select Expressions
11.1 Select Examples
12 Browser Queries
13 Dot Notation
13.1 Extracting Temporal Field Values
13.2 Dot Notation and Temporal Columns
14 More Boolean-Valued Functions
14.1 Simple Lists and List Notation
14.2 Atom Functions Apply to Lists
14.3 In
14.4 Within
14.5 Like
14.6 Bin (Binary Search)
15 Nested where Phrases
16 Aggregation
16.1 Basic Aggregation Functions
16.1.1 Kdb+ tables are Ordered
16.1.2 More Aggregation Functions
16.1.3 The Xbar Function
17 More on Insert
18 Select and Update
19 Union, Inter(sect), Except and Distinct