Mimer SQL Reference Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


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
SQL92
YES
Fully compliant.



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