ERROR: nextval: reached maximum value of sequence
Fix "ERROR: nextval: reached maximum value of sequence in PostgreSQL" - related to using serial data type to generate auto-increment columns
How to corrupt your PostgreSQL database
by
Laurenz Albe |
08.2022Of course most people do not want to corrupt their databases. These people will profit from avoiding the techniques used […]
Better SQL functions in PostgreSQL v14
by
Laurenz Albe |
07.2022We all know and value SQL functions as a handy shortcut. PostgreSQL v14 has introduced a new, better way to […]
Column order in PostgreSQL does matter
Column order can determine how quickly your data is processed in PostgreSQL. Find out how to troubleshoot performance problems in wide tables
Handling Bonus Programs in SQL
Learn how to address the issue of bonus programs in SQL, improve your understanding of PostgreSQL, and calculate bonus points efficiently
Transaction anomalies with SELECT FOR UPDATE
by
Laurenz Albe |
06.2022© Laurenz Albe 2022 I was recently confronted with a nice example of how adding FOR UPDATE to a query […]
Case-insensitive pattern matching in PostgreSQL
by
Laurenz Albe |
06.2022 (Updated on 2024-11-27) Case-insensitive search is a much-requested feature, partly (I suspect) to maintain compatibility with Microsoft SQL […]
Next to character encoding, time zones are among the least-loved topics in computing. In addition, PostgreSQL's implementation of timestamp […]
PostgreSQL 15: Using MERGE in SQL
Merge - UPDATED 2023 - a technical preview of how to merge lists with ease. Find out about a wonderful command - add power to your PostgreSQL.
PostgreSQL: mapping timestamps (date_bin)
How to map timestamps to time bins: In PostgreSQL 14, a new function date_bin has been added which maps date & time to time buckets.
