About Supported Data Types

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 |