Changes between Initial Version and Version 1 of Ticket #1411


Ignore:
Timestamp:
Oct 13, 2016, 8:12:12 AM (8 years ago)
Author:
Dimitar Misev
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #1411 – Description

    initial v1  
    55The source array in an update statement doesn't have null values associated to it, only the persistent arrays (and intermediate arrays derived from these) in the database have. If we would introduce a mechanism to attach null values to any array value, we could say that then they can be ignored in the update. Something like:
    66{{{
    7 UPDATE coll AS c SET c ASSIGN null_values(decode($1), [0:0])
     7UPDATE coll AS c SET c ASSIGN decode($1) WITH NULL VALUES [0]
    88}}}