StackRating

An Elo-based rating system for Stack Overflow

Home | About | Stats and Analysis | Get a Badge

Rating Stats for

Erwin Brandstetter

Rating
1652.91 (517th)

Reputation
567,030 (45th)

Page: 1 2 3 4 5 ... 114

Title	Δ
Get top row(s) with highest value, with ties	+0.73
Comparing TIME WITH TIME ZONE returns unexpected result	-0.08
Convert rows to columns by same column value in Postgres	-2.45
Postgres timestamp and time zone for raw UTC values	-1.92
Execute select statement conditionally	+1.93
Optimizing GROUP BY + COUNT DISTINCT on unnested jsonb column	0.00
Get list of active users per day	-0.21
Function testing whether number of rows across multiple tables is g...	+0.99
How to break ties when comparing columns in SQL	0.00
Truncate if exists in psql function and call function	0.00
Can I delete rows/replace table based on temp table	0.00
Add a row for each unique column value only if it doesn't alrea...	0.00
How to return a value from a stored procedure (not function)?	0.00
Select lexemes from unnested ts_vectors	0.00
How to use a custom function as column default in a PostgreSQL table	0.00
How to hierarchical query in PostgreSQL with language-dependent data	0.00
How to select the first number in a string	0.00
Why does distinct on in subqueries hurt performance in PostgreSQL?	0.00
Is there any query to find this id information?	0.00
SQL - Find total number of orders made for each customer	0.00
Can't change the type of a column from date to integer	0.00
Escape underscore '_' in PostgreSQL trim() function?	0.00
Fetch row with shortest date range while dealing with 'infinity...	0.00
Search with additional words at the beginning	0.00
show records that have only one matchin row in another table	0.00
Finding all rows in all tables that reference non-existent objects	0.00
Cumulative sum based on same column calculated result	0.00
Joining 2 select queries from the same table	-1.21
Is this the correct way to cast, round, and avg an object in SQL?	+1.50
UPDATE from temp table picking the "last" row per group	0.00
Filter rows if value in one column exists in another column	-0.22
PostgreSQL exclusion constraints in a bitemporal setting?	0.00
Linked lists: query first and last element of chained lists stored...	+1.52
Function returning a table for given table and column names	+1.55
Fastest way to select a lot of rows based on their ID in PostgreSQL?	-0.26
SQL set default value with a link on another column	-0.22
How to test if an argument is null in plpgsql function body?	0.00
Is it possible to make \copy insert files that have less columns th...	0.00
Aggregate numbers, some in ranges	-0.40
Problem on creating postgres stored procedure \| Postgres 12	0.00
Replace first character in SQL	-1.94
Skip rows if subquery returns multiple rows in Postgres	-0.16
Can reads occur whilst executing a bulk \copy batch of inserts	0.00
Postgres - Check if array contains an id	0.00
Can't get the name of a related table column	0.00
PostgreSQL UPDATE doesn't seem to update some rows	0.00
Count distinct customers, active within a year, for every week of t...	-1.00
How to count related rows including subcategories?	+1.32
How to replace multiple values in a single column with SQL?	+0.94
Stack depth limit exceeded in Postgres	+0.65