Skip to content
Advertisement

Update returning * and select result as rows

I want to run a few updates in a single query returning *, and select the output as rows. I currently have

That does what I’m looking for but feels like it could be improved. I almost got it working like this

but it displays as a single row not two separate rows

Advertisement

Answer

I think you simply want union all (or perhaps `union1):

User contributions licensed under: CC BY-SA
10 People found this is helpful
Advertisement