Type Precedence Lists

The following table describes the parameter overloading type precedence lists:

Data type

Precedence list

CHARACTER VARYING

CHARACTER VARYING
CHARACTER
NATIONAL CHARACTER VARYING
NATIONAL CHARACTER

CHARACTER

CHARACTER
CHARACTER VARYING
NATIONAL CHARACTER
NATIONAL CHARACTER VARYING

NATIONAL CHARACTER VARYING

NATIONAL CHARACTER VARYING
NATIONAL CHARACTER
CHARACTER VARYING
CHARACTER

NATIONAL CHARACTER

NATIONAL CHARACTER
NATIONAL CHARACTER VARYING
CHARACTER
CHARACTER VARYING

BINARY

BINARY
BINARY VARYING

BINARY VARYING

BINARY VARYING
BINARY

INTERVAL YEAR

INTERVAL YEAR
INTERVAL YEAR to MONTH
INTERVAL MONTH

INTERVAL YEAR to MONTH

INTERVAL YEAR to MONTH
INTERVAL YEAR
INTERVAL MONTH

INTERVAL MONTH

INTERVAL MONTH
INTERVAL YEAR to MONTH
INTERVAL YEAR

INTERVAL DAY

INTERVAL DAY
INTERVAL DAY to HOUR
INTERVAL DAY to MINUTE
INTERVAL DAY to SECOND
INTERVAL HOUR
INTERVAL HOR to MINUTE
INTERVAL HOUR to SECOND
INTERVAL MINUTE
INTERVAL MINUTE to SECOND
INTERVAL SECOND

INTERVAL DAY to HOUR

INTERVAL DAY to HOUR
INTERVAL DAY to MINUTE
INTERVAL DAY to SECOND
INTERVAL DAY
INTERVAL HOUR
INTERVAL HOR to MINUTE
INTERVAL HOUR to SECOND
INTERVAL MINUTE
INTERVAL MINUTE to SECOND
INTERVAL SECOND

INTERVAL DAY to MINUTE

INTERVAL DAY to MINUTE
INTERVAL DAY to SECOND
INTERVAL DAY to HOUR
INTERVAL DAY
INTERVAL HOR to MINUTE
INTERVAL HOUR to SECOND
INTERVAL HOUR
INTERVAL MINUTE
INTERVAL MINUTE to SECOND
INTERVAL SECOND

INTERVAL DAY to SECOND

INTERVAL DAY to SECOND
INTERVAL DAY to MINUTE
INTERVAL DAY to HOUR
INTERVAL DAY
INTERVAL HOUR to SECOND
INTERVAL HOUR to MINUTE
INTERVAL HOUR
INTERVAL MINUTE to SECOND
INTERVAL MINUTE
INTERVAL SECOND

INTERVAL HOUR

INTERVAL HOUR
INTERVAL HOUR to MINUTE
INTERVAL HOUR to SECOND
INTERVAL DAY to HOUR
INTERVAL DAY to MINUTE
INTERVAL DAY to SECOND
INTERVAL DAY
INTERVAL MINUTE
INTERVAL MINUTE to SECOND
INTERVAL SECOND

INTERVAL HOUR to MINUTE

INTERVAL HOUR to MINUTE
INTERVAL HOUR to SECOND
INTERVAL HOUR
INTERVAL DAY to MINUTE
INTERVAL DAY to SECOND
INTERVAL DAY to HOUR
INTERVAL DAY
INTERVAL MINUTE
INTERVAL MINUTE to SECOND
INTERVAL SECOND

INTERVAL HOUR to SECOND

INTERVAL HOUR to SECOND
INTERVAL HOUR to MINUTE
INTERVAL HOUR
INTERVAL DAY to SECOND
INTERVAL DAY to MINUTE
INTERVAL DAY to HOUR
INTERVAL DAYI
NTERVAL MINUTE to SECOND
INTERVAL MINUTE
INTERVAL SECOND

INTERVAL MINUTE

INTERVAL MINUTE
INTERVAL MINUTE to SECOND
INTERVAL HOUR to MINUTE
INTERVAL HOUR to SECOND
INTERVAL HOUR
INTERVAL DAY to MINUTE
INTERVAL DAY to HOUR
INTERVAL DAY
INTERVAL DAY to SECOND
INTERVAL SECOND

INTERVAL MINUTE to SECOND

INTERVAL MINUTE to SECOND
INTERVAL HOUR to SECOND
INTERVAL DAY to SECOND
INTERVAL MINUTE
INTERVAL HOUR to MINUTE
INTERVAL DAY to MINUTE
INTERVAL HOUR
INTERVAL DAY to HOUR
INTERVAL DAY
INTERVAL SECOND

INTERVAL SECOND

INTERVAL SECOND
INTERVAL MINUTE to SECOND
INTERVAL HOUR to SECOND
INTERVAL DAY to SECOND
INTERVAL MINUTE
INTERVAL HOUR to MINUTE
INTERVAL HOUR
INTERVAL DAY to MINUTE
INTERVAL DAY to HOUR
INTERVAL DAY

DATE

DATE

TIME

TIME

TIMESTAMP

TIMESTAMP

SMALLINT

SMALLINT
Integer(p)
INTEGER
BIGINT
DECIMAL
NUMERIC
Float(p)
REAL
FLOAT
DOUBLE PRECISION

Integer(p)

Integer(p)
INTEGER
BIGINT
DECIMAL
NUMERIC
Float(p)
REAL
FLOAT
DOUBLE PRECISION
SMALLINT

INTEGER

INTEGER
BIGINT
DECIMAL
NUMERIC
Float(p)
REAL
FLOAT
DOUBLE PRECISION
Integer(p)
SMALLINT

BIGINT

BIGINT
DECIMAL
NUMERIC
Float(p)
REAL
FLOAT
DOUBLE PRECISION
Integer(p)
INTEGER
SMALLINT

DECIMAL

DECIMAL
NUMERIC
Float(p)
REAL
FLOAT
DOUBLE PRECISION
BIGINT
INTEGER
Integer(p)
SMALLINT

NUMERIC

NUMERIC
DECIMAL
Float(p)
REAL
FLOAT
DOUBLE PRECISION
BIGINT
INTEGER
Integer(p)
SMALLINT

Float(p)

Float(p)
REAL
FLOAT
DOUBLE PRECISION
DECIMAL
NUMERIC
BIGINT
INTEGER
Integer(p)
SMALLINT

REAL

REAL
FLOAT
DOUBLE PRECISION
Float(p)
DECIMAL
NUMERIC
BIGINT
INTEGER
Integer(p)
SMALLINT

FLOAT

FLOAT
DOUBLE PRECISION
REAL
Float(p)
DECIMAL
NUMERIC
BIGINT
INTEGER
Integer(p)
SMALLINT

DOUBLE PRECISION

DOUBLE PRECISION
FLOAT
REAL
Float(p)
DECIMAL
NUMERIC
BIGINT
INTEGER
Integer(p)
SMALLINT

BOOLEAN

BOOLEAN