RhodiumToad
@RhodiumToad
Find me on IRC: #postgresql or #freebsd on http://irc.libera.chat (he/him)
You might like
Gotta love "no functional change" commits that actually cause 100% failure in an important use case
Every time I do anything that involves Linux I find new reasons to hate it.
SELECT 'Happy new year '||name FROM pg_timezone_names WHERE EXTRACT(year FROM now() AT TIME ZONE name) = 2021;
Pop quiz: posix_spawnp(&pid, "foo", ... envp) invokes a program "foo" using a search of the PATH env var. Should it use the value of PATH from the calling process' env, or the value from envp which will become the child's env? (spec at pubs.opengroup.org/onlinepubs/969… )
12 vote · Final results
Today's fun fact: "Tory" comes from the Irish word for a bandit. Any relevance to modern politics is left as an exercise for the reader
PSA: When asking for help, show YOUR OWN code / problem description, don't just point to a random forum post and say "I'm having the same problem as this". It makes it impossible to see what simple errors you may have made, or differences between your issue and the post
Wow, @jimmy_wales blocked me, for pointing out the transparency problems with his social media site.
Another SQL style tip: always a space before the paren in constructs like "OVER (", "FILTER (", etc. Avoid making things look like function calls when they're not.
SQL style tip: treat "SELECT DISTINCT" as one keyword that happens to have a space in it. Never put a newline before DISTINCT, and never put an open paren directly after it. When using COUNT(DISTINCT ...), if you absolutely need a paren, then always have a space before it.
PSA: The error message is the part that starts with "ERROR:". Any DETAIL: or HINT: that follows may be informative, but it is NOT the error message. ALWAYS READ THE ERROR MESSAGE.
So now I'm curious: to the two people who voted to keep postfix operators in my poll: why? Do you have a use case or an example of existing usage?
Quick poll: should @PostgreSQL remove support for postfix operators in expressions, or keep them? Their existence makes parsing a lot harder.
31 vote · Final results
Today's #PostgreSQL optimization tip: when dealing with queries over many tables, consider increasing from_collapse_limit and join_collapse_limit. postgresql.org/docs/current/r…
United States Trends
- 1. Thanksgiving 378K posts
- 2. Golesh 2,406 posts
- 3. Fani Willis 14.7K posts
- 4. #WipersDayGiveaway N/A
- 5. Trumplican 3,115 posts
- 6. Hong Kong 82.5K posts
- 7. Khabib 7,514 posts
- 8. Camp Haven 7,135 posts
- 9. NextNRG N/A
- 10. Tom Hardy 1,498 posts
- 11. Stranger Things 161K posts
- 12. Africans 27.2K posts
- 13. Riker N/A
- 14. Ruth 14.2K posts
- 15. Fassbender N/A
- 16. #TejRan 4,072 posts
- 17. Idris 7,467 posts
- 18. Elijah Moore 1,045 posts
- 19. Karoline Leavitt 29K posts
- 20. #PuebloEnBatallaYVictoria 4,370 posts
Something went wrong.
Something went wrong.