The following data types are supported in Hyperstage. Note that numeric data types ranges are 1 less than the PostgreSQL minimums and maximums.
Numeric Types | ||
---|---|---|
Data Type |
Minimum |
Maximum |
BOOLEAN |
Values are either 0 or 1. | |
SMALLINT |
-32767 |
32767 |
INT (INTEGER) |
-2147483647 |
2147483647 |
BIGINT |
-9223372036854775807 |
-9223372036854775807 |
REAL |
-3.402823466E+38 |
3.402823466E+38 |
DOUBLE PRECISION |
-1.7976931348623157E+308 |
1.7976931348623157E+308 |
Numeric(M, D)
where: 0 < M <= 18 and 0 <= D <= M |
-(1E+M - 1) / (1E+D) |
(1E+M - 1) / (1E+D) |
Date and Time Types | |||
---|---|---|---|
Data Type |
Minimum |
Maximum |
Format |
DATE |
100-01-01 |
9999-12-31 |
YYYY-mm-dd |
Time (without timezone) |
00:00:00 |
24:00:00 |
HH:MM:SS |
TIMESTAMP (without timezone) |
100-01-01 00:00:00 |
9999-12-31 23:59:59 |
YYYY-mm-dd HH:MM:SS |
TIME0053TAMP (with timezone) |
1970-01-01 00:00:00 in UTC |
2038-01-01 00:59:59 in UTC | |
Interval |
-178000000 years |
178000000 years |
String Type | |
---|---|
Data Type |
Maximum Length |
BYTEA (binary string) |
0 < N <= 65536 |
CHAR(N) |
Fixed-length. Maximum length depends on character set (encoding). 0 < N * B <= 65536 where B is the maximum number of bytes for a single character. |
VARCHAR(N) |
Maximum length depends on character set (encoding). 0 < N * B <= 65536, where B is the maximum number of bytes for a single character. For example, for UTF-8 it is 4 bytes, so the maximum number of characters that can be stored in a (VAR)CHAR column is 65536 / 4 = 16384 |
WebFOCUS |