Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


Result Data Types


This section describes the syntax rules for, and the resulting data types of, UNION or UNION ALL operations specified in a query-expression (see SELECT) and CASE expressions, see CASE Expression.


FLOAT(p")
INTEGER(p")
DECIMAL(p",s")
FLOAT(p')
FLOAT(p) 1
FLOAT(p) a
FLOAT(p) a
INTEGER(p')
FLOAT(p) a
INTEGER(p) a
DECIMAL(p,s) 2
DECIMAL(p',s')
FLOAT(p) a
DECIMAL(p,s) b
DECIMAL(p,s) b
1p = max(p',p")
2p = min(45, max(p'-s',p"-s")+max(s',s"))
s = max(s',s")

Thus:

SMALLINT UNION DECIMAL(10,4) gives DECIMAL(10,4)

INTEGER UNION DECIMAL(10,4) gives DECIMAL(14,4)

DECIMAL(9,2) UNION DECIMAL(6,4) gives DECIMAL(9,4).

Standard Compliance

Standard
Compliance
Comments
SQL-2003
Core
Fully compliant.


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