Changes between Initial Version and Version 4 of Ticket #1763


Ignore:
Timestamp:
Jun 10, 2018, 2:55:45 PM (6 years ago)
Author:
Dimitar Misev
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #1763

    • Property Owner set to Dimitar Misev
    • Property Status new → accepted

  • Ticket #1763 – Description

    initial v4  
    1 It should be possible to dynamically set null values to any mdd expression, e.g. marray constructor, decode, etc. It would be also useful if #1411 is fixed.
     1It should be possible to dynamically set null values to any mdd expression, e.g. marray constructor, decode, etc. The syntax is as follows:
     2{{{
     3mddExp NULL VALUES [...]
     4}}}
    25
    3 Some possibilities for the syntax for this:
    4 - `mddExpr NULL VALUES [..]`
    5 - `nullvalues(mddExpr, [..])`
     6Example:
     7{{{
     8SELECT avg_cells(1 + (c NULL VALUES [0])) FROM coll AS c
     9}}}
     10
     11Note: this replaces any previous null values of generalExp.