github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/sem/tree/testdata/eval/annotate (about) 1 # Type annotation expressions. 2 3 eval 4 ANNOTATE_TYPE('s', string) 5 ---- 6 's' 7 8 eval 9 ANNOTATE_TYPE('s', bytes) 10 ---- 11 '\x73' 12 13 eval 14 ANNOTATE_TYPE('2010-09-28', date) 15 ---- 16 '2010-09-28' 17 18 eval 19 ANNOTATE_TYPE('12:00:00', time) 20 ---- 21 '12:00:00' 22 23 eval 24 ANNOTATE_TYPE('PT12H2M', interval) 25 ---- 26 '12:02:00' 27 28 eval 29 ANNOTATE_TYPE('2 02:12', interval) 30 ---- 31 '2 days 02:12:00' 32 33 eval 34 ANNOTATE_TYPE('2 02:12:34', interval) 35 ---- 36 '2 days 02:12:34' 37 38 eval 39 ANNOTATE_TYPE('1-2 02:12', interval) 40 ---- 41 '1 year 2 mons 02:12:00' 42 43 eval 44 ANNOTATE_TYPE('2010-09-28', timestamp) 45 ---- 46 '2010-09-28 00:00:00+00:00' 47 48 eval 49 ANNOTATE_TYPE('2010-09-28', timestamptz) 50 ---- 51 '2010-09-28 00:00:00+00:00' 52 53 eval 54 ANNOTATE_TYPE(123, int) + 1 55 ---- 56 124 57 58 eval 59 ANNOTATE_TYPE(123, float) + 1 60 ---- 61 124.0 62 63 eval 64 ANNOTATE_TYPE(123, decimal) + 1 65 ---- 66 124 67 68 eval 69 ANNOTATE_TYPE(123.5, float) + 1 70 ---- 71 124.5 72 73 eval 74 ANNOTATE_TYPE(123.5, decimal) + 1 75 ---- 76 124.5 77 78 eval 79 ANNOTATE_TYPE(NULL, int) 80 ---- 81 NULL 82 83 eval 84 ANNOTATE_TYPE(NULL, string) 85 ---- 86 NULL 87 88 eval 89 ANNOTATE_TYPE(NULL, timestamp) 90 ---- 91 NULL 92 93 # Shorthand type annotation notation. 94 95 eval 96 123:::int + 1 97 ---- 98 124 99 100 eval 101 123:::float + 1 102 ---- 103 124.0 104 105 eval 106 (123 + 1):::int 107 ---- 108 124 109 110 eval 111 (123 + 1):::float 112 ---- 113 124.0 114 115 eval 116 ANNOTATE_TYPE('12:00:00-01', timetz) 117 ---- 118 '12:00:00-01:00:00'