Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site

http://developer.mimer.com


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
1
p = max(p',p")

2
p = min(45, max(p'-s',p"-s")+max(s',s"))
s = max(s',s")

Standard Compliance

Standard
Compliance
Comments
X/Open-95
SQL-92
YES
Fully compliant.



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Documentation TOC PREV NEXT INDEX