Did you know?
In PostgresQL you can update multiple rows from a select clause at once using a sub-query.
Using the UNNEST keyword function you can expand an array to a set of rows.
You can match columns from the sub-query to columns on the table you wish to update.
You can also set the column to the result returned from the sub-query.
#programming #sql #webdevelopment #javascriptdeveloper #softwareengineer #postgresql
#codeWithCipher
In PostgresQL you can update multiple rows from a select clause at once using a sub-query.
Using the UNNEST keyword function you can expand an array to a set of rows.
You can match columns from the sub-query to columns on the table you wish to update.
You can also set the column to the result returned from the sub-query.
#programming #sql #webdevelopment #javascriptdeveloper #softwareengineer #postgresql
#codeWithCipher