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 
1000101 
99991231 
YYYYmmdd 
Time (without timezone) 
00:00:00 
24:00:00 
HH:MM:SS 
TIMESTAMP (without timezone) 
1000101 00:00:00 
99991231 23:59:59 
YYYYmmdd HH:MM:SS 
TIME0053TAMP (with timezone) 
19700101 00:00:00 in UTC 
20380101 00:59:59 in UTC 

Interval 
178000000 years 
178000000 years 
String Type 


Data Type 
Maximum Length 
BYTEA (binary string) 
0 < N <= 65536 
CHAR(N) 
Fixedlength. 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 UTF8 it is 4 bytes, so the maximum number of characters that can be stored in a (VAR)CHAR column is 65536 / 4 = 16384 
WebFOCUS  
Feedback 