klin

klin has asked 0 questions and find answers to 491 problems.

Stats

About

Some believe that queries written in uppercase are executed faster because the server hears them better. That's nonsense. The truth is that smaller letters squeeze faster through tight cables.

klin questions

klin answers

Retrieve data from JSON object
Inconsistencies Casting to Double-Quoted Types
In Postgresql what to pass in WHERE clause for enum type of column to select all types?
Recursive query for hirarchical data based on adjacency list
How to query postgres for jsonb field that has a key set to a null value
Group and calculate percentages of each distinct value
How to pivot or 'merge' rows with column names?
Create "counter" array in psql
Select column values alternatively with predefined value order
How to create a subset of a table