File: numeral.sql

package info (click to toggle)
postgresql-numeral 1.3-5
  • links: PTS, VCS
  • area: main
  • in suites: bookworm
  • size: 196 kB
  • sloc: ansic: 370; yacc: 242; sql: 194; lex: 169; makefile: 37; sh: 19
file content (79 lines) | stat: -rw-r--r-- 2,095 bytes parent folder | download | duplicates (4)
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
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
SELECT '0'::numeral;
SELECT '1'::numeral;
SELECT '-2'::numeral;

SELECT 'zero'::numeral;

SELECT 'one'::numeral;
SELECT 'minus one'::numeral;
SELECT 'two'::numeral;
SELECT 'three'::numeral;
SELECT 'four'::numeral;
SELECT 'five'::numeral;
SELECT 'six'::numeral;
SELECT 'seven'::numeral;
SELECT 'eight'::numeral;
SELECT 'nine'::numeral;
SELECT 'ten'::numeral;

SELECT 'eleven'::numeral;
SELECT 'twelve'::numeral;
SELECT 'thirteen'::numeral;
SELECT 'fourteen'::numeral;
SELECT 'fifteen'::numeral;
SELECT 'sixteen'::numeral;
SELECT 'seventeen'::numeral;
SELECT 'eighteen'::numeral;
SELECT 'nineteen'::numeral;

SELECT 'twenty'::numeral;
SELECT 'twenty-one'::numeral;
SELECT 'thirty'::numeral;
SELECT 'thirty-two'::numeral;
SELECT 'forty'::numeral;
SELECT 'fifty'::numeral;
SELECT 'sixty'::numeral;
SELECT 'seventy'::numeral;
SELECT 'eighty'::numeral;
SELECT 'ninety'::numeral;

SELECT 'hundred'::numeral;
SELECT 'one hundred'::numeral;
SELECT 'hundred one'::numeral;
SELECT 'one hundred one'::numeral;
SELECT 'one hundred twenty-one'::numeral;

SELECT 'two hundred'::numeral;
SELECT 'two hundred one'::numeral;
SELECT 'two hundred thirty-two'::numeral;

SELECT 'thousand'::numeral;
SELECT 'one thousand'::numeral;
SELECT 'one thousand one'::numeral;
SELECT 'thousand one hundred'::numeral;
SELECT 'one thousand one hundred'::numeral;
SELECT 'eleven hundred'::numeral;
SELECT 'one thousand one hundred one'::numeral;

SELECT 'hundred thousand'::numeral;
SELECT 'one hundred thousand'::numeral;
SELECT 'one hundred one thousand'::numeral;
SELECT 'two hundred thousand'::numeral;

SELECT 'one million'::numeral;
SELECT 'one million one'::numeral;
SELECT 'one million one hundred'::numeral;
SELECT 'one million one thousand'::numeral;
SELECT 'one million one hundred thousand'::numeral;
SELECT 'two million'::numeral;

SELECT 'hundred million'::numeral;

SELECT 'one billion'::numeral;
SELECT 'one billion one million'::numeral;
SELECT 'one billion one million one thousand'::numeral;

SELECT 'billion'::numeral;
SELECT 'trillion'::numeral;
SELECT 'quadrillion'::numeral;
SELECT 'quintillion'::numeral;