News for hackers. Stuff that matters.

A comment on SQL Tips and Tricks.

Re:SQL Tips and Tricks by l5870uoo9y on Wednesday September 25, 2024 @02:57AM (#41644459)
And I take it CTEs are implicitly being discouraged.
[ Parent | on HN ]
Re:SQL Tips and Tricks by higeorge13 on Wednesday September 25, 2024 @03:47AM (#41644821)
It used to be like this (i remember in past postgres versions CTEs had worse performance than subqueries), but not anymore.
[ Parent | on HN ]
Re:SQL Tips and Tricks by regexman1 on Wednesday September 25, 2024 @03:02AM (#41644482)
Not at all actually, I just hadn't really planned to add this as a tip. Additionally I thought an in-line view was fine for the examples included. But maybe I will!
[ Parent | on HN ]