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, INTERSECT and EXCEPT 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")

Standard Compliance

Standard
Compliance
Comments
SQL-2016
Core
Fully compliant.


Mimer
Mimer Information Technology AB
Phone: +46 18 780 92 00
info@mimer.com
Mimer SQL Documentation TOC PREV NEXT INDEX