News for hackers. Stuff that matters.
Re:Ask HN: Have you ever used PL/pgSQL – the PostgreSQL prog... by tomlock on Monday September 03, 2018 @08:38PM (#17905767)
These are both great observations.

VOLATILE/STABLE/IMMUTABLE is definitely a choice worth considering and making in an educated way when writing a function.

Also, using WITH to create CTEs makes SQL easy to read, but sometimes will slow down a query considerably. I have a feeling that new releases will make attempts to mitigate this issue in some cases.

There are no comments on this comment yet.