Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


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


Mimer
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
info@mimer.se
Mimer SQL Documentation TOC PREV NEXT INDEX