blob: 457d2d110c5073567c8a1f1546cfe8315dff5db1 (
plain) (
blame)
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
|
/* postgres can not */
select Bool("true");
select Bool("FalsE");
select Int8("-128");
select Int8("127");
select Uint8("0");
select Uint8("255");
select Int16("-32768");
select Int16("32767");
select Uint16("0");
select Uint16("65535");
select Int32("-2147483648");
select Int32("2147483647");
select Uint32("0");
select Uint32("4294967295");
select Int64("-9223372036854775808");
select Int64("9223372036854775807");
select Uint64("0");
select Uint64("18446744073709551615");
select Float("0");
select Float("1");
select Float("-1e30");
select Float("-inf");
select Float("+inf");
select Float("nan");
select Double("0");
select Double("1");
select Double("-1e300");
select Double("-inf");
select Double("+inf");
select Double("nan");
select String("foo\xffbar");
select Utf8("привет");
select Yson("<a=1>[3;%false]");
select Json(@@{"a":1,"b":null}@@);
select cast(Date("2000-01-01") as string);
select cast(Datetime("2000-01-01T01:02:03Z") as string);
select cast(Timestamp("2000-01-01T01:02:03.4Z") as string);
select cast(Interval("P1DT12H") as string);
select TZDATE("2010-07-01,Europe/Moscow");
select TZDATE("2010-07-01,America/Los_Angeles");
select TZDATETIME("2010-07-01T00:00:00,Europe/Moscow");
select TZTIMESTAMP("2010-07-01T00:00:00,America/Los_Angeles");
select TZTIMESTAMP("2010-07-01T12:00:00.123456,Europe/Moscow");
select Uuid('550e8400-e29b-41d4-a716-446655440000');
|
