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 ... 12 13 14 15 16 ... 114

Title	Δ
Convert VARCHAR to INT/NUMBER in WHERE clause	+0.28
Select rows with value > x inside nested json array	-0.20
LIKE query on elements of flat jsonb array	0.00
I have different results from query for COUNT('e.id') or CO...	0.00
ERROR: column "semester_id" is of type integer but expres...	0.00
Invalid input syntax for type numeric: "(0.0000000000000000,8)...	+1.61
ERROR: argument of OR must not return a set	+1.52
Calculating rates in PostgreSQL	-0.55
Comparing two dates in a SQL request	-0.32
Creating dynamic columns from table data	0.00
Getting duplicates when joining on the same table twice and another...	-0.71
Function shows error "relation my_table does not exist"	0.00
unaccent() does not work with Greek letters in plpgsql dynamic query	0.00
Search a JSON array for an object containing a value matching a pat...	+0.22
Sort int range as PostgreSQL date range	+1.35
Dynamic ORDER BY and ASC / DESC in a plpgsql function	0.00
Get all rows if keyword is null else return matching	-0.67
Postgres query result to json object	+1.45
Separate subselects to get multiple counts?	+1.76
Query returning different number of rows, results in crosstab error	0.00
Adding ORDER BY to SQL query explodes runtime	0.00
Sum time differences across multiple timezones in PostgreSQL	0.00
How to get a output of a variable from function in postgresql	+0.33
Postgresql trigger operating on both NEW and OLD records	0.00
Get the numeric part followed by 1 place of decimal in PostgreSQL i...	-0.46
Replace delete with trigger function: how to return affected row co...	+0.31
Speed up range test for key values nested in jsonb array of objects	+0.34
How do I change a time column to an integer column in PostgreSQL wi...	-0.35
Setting variable in a Postgres function	-2.40
Postgres real rounds to 4 decimal places	0.00
How to sort objects in an array inside a json or jsonb value by a p...	0.00
How to lookup based on ranged values	0.00
Index usage explanation	0.00
Creating user with password from variables in anonymous block	0.00
Find a latest gap between Unix timestamps	0.00
Handling unique constraint exceptions caused by inserting duplicate...	0.00
How to avoid explicit casting NULL during INSERT in Postgresql	+0.53
Cannot use variable with EXECUTE command in plpgsql function	0.00
Check for enum types PostgreSQL function	0.00
Efficient way to select one from each category - Rails	-1.44
PostgreSQL: Order by multiple column weights	-0.93
extract all numbers in a string	-0.94
Counting number of weekdays between two dates	+1.32
Select first row in a group by, with several columns defining the g...	+1.40
LIKE clause on text field with "\|" returns no results	0.00
Return boolean type in PostgreSQL	-2.58
Query for users with only inactive push tokens	-1.91
Postgres directed graph traversal up AND down	0.00
Null value in column "logit" violates not-null constraint	-0.34
Workaround for using aggregate function in WHERE for an UPDATE stat...	0.00