File: float.test

package info (click to toggle)
groonga 16.0.0%2Bdfsg-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 188,416 kB
  • sloc: ansic: 772,827; cpp: 52,396; ruby: 40,556; javascript: 10,250; yacc: 7,045; sh: 5,627; python: 2,821; makefile: 1,679
file content (27 lines) | stat: -rw-r--r-- 447 bytes parent folder | download | duplicates (6) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
 
plugin_register functions/number

table_create Prices TABLE_PAT_KEY Float

load --table Prices
[
{"_key": -200.5},
{"_key": -200},
{"_key": -199.5},
{"_key": -100.5},
{"_key": -100},
{"_key": -99.5},
{"_key": -0.5},
{"_key": 0.0},
{"_key": 0.5},
{"_key": 99.5},
{"_key": 100},
{"_key": 100.5},
{"_key": 199.5},
{"_key": 200},
{"_key": 200.5}
]

select Prices \
  --sortby _id \
  --limit -1 \
  --output_columns '_key, number_classify(_key, 100)'