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-2011
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