On 24 October 2016 at 22:16, Ali Akhtar <ali.rac...@gmail.com> wrote:
> *UPDATE movie set ratings.rating = 5 WHERE ratings.user = 'bob'* You won't be able to do this because you're trying to update a row without specifying the primary key. Also, even if you did add the PK to the where, you've specified a list of (frozen) ratings, so ratings.rating and ratings.user doesn't make sense. Collection types can't be part of the primary key, so updating as you've mentioned above won't really be possible. Kurt Greaves k...@instaclustr.com www.instaclustr.com