Craig Kerstiens About Travel & Wine My Recommendations Top Content Archive Menu About Travel & Wine My Recommendations Top Content Archive - <a class="addthis_counter addthis_pill_style"></a> - I find during the holiday season many pick up new books , learn a new language , or brush up on some other skill in general. Here’s my contribution to hopefully giving you a few new things to learn about Postgres and ideally utilize in the new year. It’s not in a top 10 list as much as 10 tips and tricks you should be aware of as when you need them they become incredibly handy. more CTEs allow you to do crazy awesome things like recursive queries but even the most simple form of them I don’t go a day without using. Think of a CTE or commonly known as with clause as a view inside the time that query is running. This lets you more easily create readable query...