PostgreSQL Datatype | RWDBValue:: ValueType | C++ Datatype |
bigint | LongLong | long long |
bigserial | LongLong | long long |
bit bit varying(n) | String | |
boolean | String | |
box | String | |
bytea | Blob | |
char(n) | String | |
varchar(n) | String | |
cidr | String | |
circle | String | |
date | Date | |
double precision | Double | double |
inet | String | |
integer | Long | long int |
interval(p) | Duration | |
line | String | |
lseg | String | |
macaddr | String | |
money | String | |
numeric | Decimal | |
path | String | |
point | String | |
polygon | String | |
real | Float | float |
smallint | Short | short int |
serial | Long | long int |
text | String | |
time(p)1 | DateTime | |
time(p) with time zone1 | DateTime | |
timestamp(p)1 | DateTime | |
timestamp(p) with time zone1 | DateTime |
RWDBValue::ValueType | PostgreSQL Datatype |
Blob | bytea |
Char UnsignedChar Tiny UnsignedTiny Short UnsignedShort | smallint |
Date | date |
DateTime | timestamp[(p)] using precision of column if specified |
Decimal | numeric(p,s) using precision and scale of column if specified |
Duration | interval[(p)] using precision of column if specified |
Double | double precision |
Float | real |
Int UnsignedInt | integer |
Long UnsignedLong | integer |
LongLong UnsignedLongLong | bigint |
String | varchar(n) if storageLength is specified, else text |
RWDBValue::ValueType | Restrictions |
Blob | No restrictions |
Char UnsignedChar | No restrictions |
Date | Only the PostgreSQL DateStyle ISO, MDY is supported. |
DateTime | RWDateTime is limited to milliseconds, but PostgreSQL can support a much finer precision. PostgreSQL's timestamp type supports a range from 4713 BC to 5874897 AD. However, RWDateTime is limited to a datetime range of 09-14-1752 00:00:00.000 to 9999-12-31 23:59:59.999 Only the PostgreSQL DateStyle ISO 8601 format in MDY mode is supported. |
TimeTuple | Only the PostgreSQL DateStyle ISO 8601 format in MDY mode is supported. |
TimeTupleOffset | This datatype is not supported. |
Decimal | No restrictions |
Double | No restrictions |
Duration | No restrictions |
Float | No restrictions |
Int UnsignedInt | No restrictions |
Long UnsignedLong | No restrictions |
MBString | This datatype is not supported. |
LongLong UnsignedLongLong | No restrictions |
LongDouble | No restrictions |
String | No restrictions |
Short UnsignedShort | No restrictions |
WString | This datatype is not supported. |
UString | This datatype is not supported. |