Nano second support in GPDB
Article ID: 296847
Updated On:
Products
VMware Tanzu Greenplum
Environment
Product Version: 6.21
Resolution
Checklist:
Some users may find some needs to use NANOSECOND in Timestamp data type in GPDB based on their business requirements. So they may have concern on whether GPDB supports NANOSECOND?
GPDB does not support nanosecond in timestamp for now(at this point of time when the KB article is being written). But fortunately, a new feature to support timestamp(9) had been in development process and expected to be released with GPDB 6.23.
The new feature is to integrate a Postgres-related extension into GPDB:
https://github.com/fvannee/timestamp9
Some users may find some needs to use NANOSECOND in Timestamp data type in GPDB based on their business requirements. So they may have concern on whether GPDB supports NANOSECOND?
GPDB does not support nanosecond in timestamp for now(at this point of time when the KB article is being written). But fortunately, a new feature to support timestamp(9) had been in development process and expected to be released with GPDB 6.23.
The new feature is to integrate a Postgres-related extension into GPDB:
https://github.com/fvannee/timestamp9
Feedback
Yes
No
Powered by
