Skip to main content
The 2026 Annual Developer Survey is live— take the Survey today!
klin's user avatar
klin's user avatar
klin's user avatar
klin
  • Member for 13 years, 6 months
  • Last seen this week
  • Poland
Profile Activity

Profile

Stats

123,907
reputation
9.2m
reached
2,280
answers
2
questions
Communities
View all

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.

Badges

View all badges
15
gold badges
244
silver badges
265
bronze badges

Top tags

View all tags
9,630
Score
2,263
Posts
99
Posts %
2,896
Score
830
Posts
36
Posts %
2,126
Score
290
Posts
13
Posts %
1,873
Score
295
Posts
13
Posts %
1,280
Score
208
Posts
9
Posts %
990
Score
166
Posts
7
Posts %

Top posts

View all questions, answers, and articles
answer
427
How to list indexes created for table in postgres
May 19, 2016
answer
244
Postgres unique constraint vs index
May 14, 2014
answer
179
Refresh a materialized view automatically using a rule or notify
May 30, 2014
answer
171
How do I search for a specific string in a JSON Postgres data type column?
Aug 23, 2017
answer
141
PostgreSQL rename attribute in jsonb field
Feb 17, 2017
answer
122
PostgreSQL: Drop a function without parameters
Jun 11, 2015
answer
99
in postgres select, return a column subquery as an array?
Jul 16, 2015
answer
85
Postgresql query for objects in nested JSONB field
Feb 9, 2017
answer
80
In postgresql, how can I return a boolean value instead of string on a jsonb key?
Oct 9, 2015
answer
79
default for column "xxxx" cannot be cast automatically to type boolean in Postgres DB
Dec 14, 2016

Top network posts

View all network posts
66
Size limit of character varying Postgresql
16
How can I return multiple rows of records in PL/pgSQL
13
PostgreSQL Upsert not working on Partitioned Table
12
Postgres : Truncate if exists in psql function with parameter
11
Return a record with PL/pgSQL function - to speed up the query