Re: A case for UPDATE DISTINCT attribute

2018-12-20 Thread Alexey Bashtanov
Hello Gajus, I have observed that the following pattern is repeating in our data management programs: UPDATE   event SET   fuid = ${fuid},   venue_id = ${venueId},   url = ${url} WHERE   id = ${id} AND   fuid IS != ${fuid} AND   venue_id IS != ${venueId} AND   url IS DISTINCT FROM ${url}; ..

A case for UPDATE DISTINCT attribute

2018-12-14 Thread Gajus Kuizinas
I have observed that the following pattern is repeating in our data management programs: UPDATE event SET fuid = ${fuid}, venue_id = ${venueId}, url = ${url} WHERE id = ${id} AND fuid IS != ${fuid} AND venue_id IS != ${venueId} AND url IS DISTINCT FROM ${url}; Note: "url" can be n