Supported Types of Preference SQL

The well-known data types of SQL are supported with respect to the type of the preference constructor as listed on this page.

Categorical Preference Constructors

All categorical preference constructors handle these data types:

Character strings
* CHARACTER(n) or CHAR(n) — fixed-width n-character string, padded with spaces as needed
* CHARACTER VARYING(n) or VARCHAR(n) — variable-width string with a maximum size of n characters

Numerical Preference Constructors

All numerical preference constructors handle these data types:

Numbers

• INTEGER and SMALLINT
• FLOAT, REAL and DOUBLE PRECISION
• NUMERIC(precision, scale) or DECIMAL(precision, scale)

• DATE — for date values

• TIME without timezone - for time values

TIMESTAMP without timezone - for values of date and time

INTERVAL - for intervals of date and time

For the zero time interval:

For 1 month, 1 day:

For -1 months, 1 day, -30 miinutes:

For 1 day, 1 millisecond:

For 1 month:

For 10 seconds:

There are also Type TIMESTAMP WITH TIMEZONE and TIME WITH TIMEZONE in PostgreSQL (Constructors TIMETZ and TIMESTAMPZ). They are not supported in PreferenceSQL yet.

In PostgreSQL the granularity is 1 microsecond. Refer to the PostgreSQL Documentation for details.