For update I tried the following it works, but there is no way to not modify the lower bound
validityu = %Postgrex.Range{upper: 100, upper_inclusive: false}
# from(p in table_name, where: p.subject == ^subject , update: [set: [validity: ^validityu]])
# |> Repo.update_all([])
In my original queryI have
UPDATE default_name SET
validity = int4range(lower(validity), 0, ‘[)’)
where subject = ‘Sai’ and validity @> 0; which retains the current lower. Looks like this is not possible with Repo.update_all()
