Go search for something like "postgres cte" and you won't find anything useful until probably halfway down the page. And maybe not at all.
https://www.postgresqltutorial.com/postgresql-tutorial/postg...
The first result was the official documentation.
What else are you expecting?
What I'm wondering is how much of your recognized fingerprint influences the results? What causes results to be different from user to user using the same search query?
Those training wheel search results are annoying but they're highly ranked probably because most people like and use them.
Now that you know about blogspam, we'll move on to the next topic: How to find blogspam. It's actually very easy to find blogspam. You are on the right page if you want to learn about finding blogspam..."
Instead of a dark forest (https://en.wikipedia.org/wiki/The_Dark_Forest) think of the outer internet as a fake forest. If you wander off the beaten path - the same dozen sites that everyone uses and complains about - you wander into an endless, trackless zone of fakes all of which are ultimately trying to sell you something.
Made me imagine the invention of the internet as the big bang, and that now we are watching the expansion of e-space as all the useful bodies rush away from one another and the light-years of space between them is filled by a vacuum of usefulness.
Maybe one day the search for intelligent life in space will be easier than the search for intelligent life on the internet.
https://kagi.com/search?q=postgres+cte&r=us&sh=5-n8GUySt5qmx...
Neither of them offers bad results, but we are talking about google, it makes no sense to give example searches without saying what results you receive as Google is so heavily personalized.
Kagi does personalization, but it’s explicit. You yourself decide the region to search in (my default is international, though there are quick bangs to search in other regions), and you can up- or downrank domains, as well as block them completely.
[1] https://www.postgresql.org/docs/current/queries-with.html
It's also the site I used more as a kid so there's probably some loyalty bias.
Now, I will admit that for this particular query Kagi and Google results are pretty close. But my general experience is that when I search in Google I find that I have to look farther down the search results to look past the blogspam to find the authoritative reference.