Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


Default Values


There are various places in the Mimer SQL syntax where a default value can be specified. The value resulting from a default value specification must always be assignment-compatible with the data type of the context to which it will be applied.

In the syntax diagrams, the term default-value may be replaced by the following construction:



For more information about what can be specified for literal, see Literals.

Standard Compliance

This section summarizes standard compliance concerning the specification of default values.

Standard
Compliance
Comments
SQL-2003
Core
Fully compliant.
SQL-2003
Features outside core
Feature F555 "Enhanced seconds precision" Localtime and Localtimestamp functions with fractions of seconds.

Mimer SQL extension
NEXT_VALUE OF and CURRENT_VALUE OF sequences are Mimer SQL extensions.


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