domm on Nostr: Today I learned about LEAD() in Postgres Window Functions, which returns the row ...
Today I learned about LEAD() in Postgres Window Functions, which returns the row after the current row in a partition of data. Very handy! #Postgres
domm
npub1nl…rdpf5
2026-06-26 10:32:13 UTC
Author Public Key
npub1nl57xtmzmdk4dhlfmyl2x0wchxhquv3j8fgqdyuzggtncfnpqkeqmrdpf5Seen on
wss://relay.momostr.pinkPublished at
2026-06-26 10:32:13 UTCEvent JSON
{
"id": "ef182d767f02f2e6fb94ca9b3fd8425eca508741f46558621b77cd71b59def33",
"pubkey": "9fe9e32f62db6d56dfe9d93ea33dd8b9ae0e32323a5006938242173c266105b2",
"created_at": 1782469933,
"kind": 1,
"tags": [
[
"t",
"postgres"
],
[
"proxy",
"https://social.linux.pizza/@domm/116815949529315122",
"web"
],
[
"proxy",
"https://social.linux.pizza/users/domm/statuses/116815949529315122",
"activitypub"
],
[
"L",
"pink.momostr"
],
[
"l",
"pink.momostr.activitypub:https://social.linux.pizza/users/domm/statuses/116815949529315122",
"pink.momostr"
],
[
"-"
]
],
"content": "Today I learned about LEAD() in Postgres Window Functions, which returns the row after the current row in a partition of data. Very handy! #Postgres",
"sig": "fed5dee8e46728f9d190ec7a8617374ac0853371ad3acbb3bc81e4242762b59d87c5b3e82d59355c77b79e49157e1538319fad80a12545c25576605468a78802"
}