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

Title	Δ
INSERT values from "group by" query into another table	-1.10
How to use LIKE on elements of a JSONB array?	0.00
Generate date series with repeating dates	0.00
How to split a value across a start and end date using SQL?	-1.63
Prohibit users from updating a column if another column is null?	-1.46
Deadlock when using SELECT FOR UPDATE	0.00
Replace values in array column with related values from another table	-0.19
Optimize query on big table executing generate_series()	0.00
Function to insert data into different tables	0.00
Multiple conditions in INNER JOIN	-2.42
Rank order ST_DWithin results by the number of radii a result appea...	0.00
Change {NULL} in Postgres ARRAY to NULL	0.00
Setting a value to the result of a subquery in a function in postgr...	+0.18
How to store comma-separated values row by row in postgresql	-1.84
PL/pgSQL function won't run correctly outside pgAdmin	0.00
Timestamp with timezone error in postgresql prior to 1892	+0.30
Conditionally drop an insert in a before insert trigger without ret...	0.00
PostgreSQL: how to get & set an enumerated list variable in a s...	-1.87
How to optimize query to compute row-dependent datetime relationshi...	+1.41
Select if string contains substring only once	-0.48
Aggregate numeric values from jsonb array of records (including NUL...	0.00
Query to match foreign key relationships	+0.29
Function's final statement must be SELECT or INSERT UPDATE DELE...	0.00
DISTINCT on XML with CAST	0.00
Is RIGHT JOIN the way to go with this query?	+1.29
ERROR: function regexp_matches(jsonb, unknown) does not exist in Ta...	0.00
Conditionally replace single value per row in jsonb column	-1.28
How to check if a column has all increasing values in PostgreSQL	-0.49
Postgres Double Precision to Date	0.00
Matching Many To Many relation	-0.56
Calculate center for each polygon in a list efficiently	0.00
How to iterate over SELECT query results in PL/pgSQL?	0.00
Storing hours, minutes and seconds effectively	-0.68
Skip whole row if aggregated value is null	+0.30
LIMIT with ORDER BY makes query slow	0.00
How do I know if any index is used in a query \| PostgreSQL 11?	+1.54
Sequential increment skipping numbers	0.00
Query too slow for just 4 tables with 50000 rows each	0.00
Query execution time increased dramatically without type cast	0.00
Get rows based on the existence of related rows in the same table	+0.31
Delete selected tables from Postgres sql	+0.03
PostgreSQL id column not defined	+1.55
LEFT JOIN using a link table in PostgreSQL	0.00
Aggregate timestamp values by the according day in a given time zone	0.00
Comparing row value with text fields to row of untyped string liter...	0.00
Remove duplicates from a table and re-link referencing rows to the...	-0.54
Best way to count number of descendants from ancestors array?	+1.92
Getting an Error while using EXCEPT clause	-0.31
Convert strings of varying pattern to date	0.00
SELECT ... FOR UPDATE SKIP LOCKED in REPETABLE READ transactions	0.00