Craig Kerstiens • 5/8/2015

Upsert lands in PostgreSQL 9.5 – A first look

Read Original

This article provides an early exploration of the UPSERT feature committed for PostgreSQL 9.5. It explains the concept of 'create or update', demonstrates the new SQL syntax with a practical web scraper example, and discusses how it resolves unique constraint violations safely without race conditions.

0 comments
#database #sql #postgresql
Upsert lands in PostgreSQL 9.5 – A first look

Comments

No comments yet

Be the first to share your thoughts!

Browser Extension

Get instant access to AllDevBlogs from your browser

Top of the Week

1
The Beautiful Web
Jens Oliver Meiert • 2 votes
2
When your coding agent doesn’t understand your project, you’ll get junk
Benjamin Cane • 1 votes
3
LLM Use in the Python Source Code
Miguel Grinberg • 1 votes
4
Wagon’s algorithm in Python
John D. Cook • 1 votes
5
An example conversation with Claude Code
Dumm Zeuch • 1 votes