3 posts tagged with "return"

    handling empty arrays with postgres

    2022-11-28

     | 

    ~2 min read

     | 

    258 words

    A few days ago, I wrote about handling arrays from Javascript to SQL. Turns out, I missed an edge case - empty arrays. If you try to set an…

    array handling: javascript to sql

    2022-11-28

     | 

    ~2 min read

     | 

    298 words

    Yesterday we updated a Postgres record’s details based on the and returned the update in a single query. What if the details was not a…

    postgres `returning` statement

    2022-11-28

     | 

    ~2 min read

     | 

    239 words

    Often, after making a change to a database, we want to verify that the change was made and use the updated rows. A naïve approach would be…

Return to all tags