Attach null values to an mdd expression

[Dimitar Misev]

It should be possible to dynamically set null values to any mdd expression, e.g. marray constructor, decode, etc. The syntax is as follows:

mddExp NULL VALUES [...]

Example:

SELECT avg_cells(1 + (c NULL VALUES [0])) FROM coll AS c

Note: this replaces any previous null values of mddExp.

[Peter Baumann]

I'd prefer common SQL style "expr NULL VALUES", with low binding priority.
Hm…nothing like that in SQL/MDA?

[Dimitar Misev]

No, null values as we have it is not in SQL/MDA.

[Peter Baumann]

maybe you could start an enhancement list for an SQL/MDA v1.1 ?

[Peter Baumann]

a good move! How could an existing null value set get updated?

[Dimitar Misev]

The null values specified in place like this replace the existing null values.