@Chaotica You can also use '1 week'.
Member of the SQL Committee
Fan of MLB and WFTDA and pretty much no other sport.
he/him/his
I follow hashtags more than I follow people. Tag your posts!
Vik Fearing
@xocolatl
- 163 Followers
- 75 Following
- 497 Posts
@clonezone
Not quite. It treated the NULL as unknown and waited for the next branch of the set operation. You likely either had another NULL there, or a character string literal. It gives up there and goes to text instead of looking for the next arm of the setop.
bram dingelstad 
going to be referring to postgres as "spicy excel" from here on out
Nicolas MartyanoffFun fact, #PostgreSQL limits identifiers to 63 bytes. This is reasonable.
But it will accept creation of resources with identifiers longer than that and automatically truncate them with nothing more than a notice-level log message.
I sincerly hope the SQL standard mandates this because if not, it is a puzzling, bug-inducing choice.
The SQL Standard mandates that identifiers accept at least 128 characters (not octets).
The #PostgreSQL decision to only allow 63 octets is an arguably reasonable choice. Its decision to silently truncate is absolutely abhorrent.
Nordic PGDayCome see Vik Fearing (@xocolatl) talk about "Window Functions Are Easier and More Powerful Than You Think" at Nordic PGDay in Copenhagen!
pgDay ParisCome see Ellyne Phneah talk about "Tuning community parameters: Hosting PostgreSQL events that perform"!
Stefan Fercot
In case you missed the info on other platforms, we're gonna have a #PostgreSQL #meetup in Paris next month on Thursday 13th March (the week before @pgDayParis) and I'll be there speaking about incremental backups (and a little bit about #pgBackRest 🤫)
https://www.meetup.com/postgresql-user-group-paris/events/305774177
I just completed "LAN Party" - Day 23 - Advent of Code 2024 #AdventOfCode https://adventofcode.com/2024/day/23
https://github.com/xocolatl/advent-of-code/blob/master/2024/dec23.sql
I just completed "Monkey Market" - Day 22 - Advent of Code 2024 #AdventOfCode https://adventofcode.com/2024/day/22
https://github.com/xocolatl/advent-of-code/blob/master/2024/dec22.sql