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 ... 10 11 12 13 14 ... 114

Title	Δ
Convert json object to recordset?	+0.31
Get row from one table, plus COUNT from a related table	-2.38
Simple regex to filter out pre and suffix characters	-1.32
Execute a SELECT with dynamic ORDER BY expression inside a function	-1.77
SQL query to find a row with a specific number of associations	+0.77
Updating a column from the results of a counting subquery	-2.44
Function to return N significant digits of given number	-0.79
Most efficient way to query data nested deep in JSON arrays?	0.00
Multiply an array from a column with the result of a count from ano...	0.00
JOIN 3 tables (or cross join?) and output 2 times users.name value	+0.30
Is it possible to cache variable in PostgreSQL function?	0.00
Set search_path with file include in postgres psql command	0.00
How to show all dates from a certain date range in horizontal row?	0.00
Long running function locking the database?	+0.30
How to show all date from a certain Month by horizontally?	0.00
Why doesn't the timezone changes in these SQL expressions?	0.00
Type error while looping through array in PL/pgSQL	0.00
Update column with input from a VALUES expression without explicit...	0.00
Batch delete in Postgres using a cursor	0.00
Regex to validate if string is valid SQL column name	-0.49
Postgres function logging and raising an exception	0.00
SELECT with sorting and counting by a joined table	+0.70
Function to select column values by comparing against comma separat...	-1.94
What is the most performant way to rewrite a large IN clause?	0.00
Postgres full text search on json	0.00
Postgres UPSERT reuse column values from INSERT on UPDATE	0.00
Postgresql group by for multiple lines	+1.49
Count Distinct values in one column based on other columns	-1.15
Sum with aggregate date postgresql	0.00
Show arguments that matched in result	0.00
WHERE clause operator based on column value	+1.57
Find unmatched rows between two tables	-0.95
Using an if else for a value in one table to insert data into anoth...	+1.70
.pgpass file for more than one user	0.00
Average of successive pairs of rows	+1.45
Group and count by another columns value	+0.29
Why am I getting syntax error at or near "@"	-1.50
Extract Value from a string PostgreSQL	+1.45
Query to get dependant view definition and details for given table...	0.00
Multi-column indexes and ORDER BY	0.00
How to use variable settings in trigger functions?	+0.25
High number of live/dead tuples in postgresql/ Vacuum not working	-1.26
Total percentage of a series of positive and negative percentages	+1.46
Unordered result using order by query	0.00
Concatenation of tsvectors results in a syntax error in Postgres 9....	0.00
GROUP BY consecutive rows where columns are equal or NULL	-0.45
Postgres using partial index on enum type for equality condition bu...	0.00
Unique constraint on JSONB null field	0.00
Update JSONB column data from other columns in same table	-0.20
Postgres accessing row values in a FOR loop	+2.19