Luca Ferrari

Open Source advocate, human being

A recursive CTE to get information about partitions I was wondering about writing a function that provides a quick status about partitioning. But wait, PostgreSQL has recursive CTEs! written sometime in June 2019 Tags: postgresql , planet-postgresql-org
Checking the sequences status on a single pass It is quite simple to wrap a couple of queries in a function to have a glance at all the sequences and their cycling status. written sometime in June 2019 Tags: postgresql , planet-postgresql-org	Happy Birthday Java! Java has just turned 24 years old. Happy Birthday Java! written sometime in June 2019 Tags: java , perl5
FizzBuzz (in both plpgsql and SQL) While listening to a great talk by Benno Rice, I was pointed to the FizzBuzz alghortim. How hard could it be to implement it using PostgreSQL? written sometime in June 2019 Tags: postgresql , planet-postgresql-org	The MOO (best colleague ever) The Moo always reminds me about a nice colleague I had… written sometime in May 2019 Tags: misc

Newer articles Older articles
There are 1223 total articles on this blog, you are viewing page 34 of 245.

A recursive CTE to get information about partitions