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 ... 16 17 18 19 20 ... 114

Title	Δ
Accessing aggregate in nested subquery	0.00
How to change the data type of a table column to enum?	0.00
In Postgres, how do you extract the month (according to specific ti...	-0.71
Replace an entire field value in a file using awk or other	+1.07
Best practice to enforce uniqueness on column but allow some duplic...	+1.06
Populate a Postgres table with old values from a function (not a tr...	+1.58
ALL operator in WHERE clause in Rails	+0.31
How to return a table's rowtype plus an additional column from...	+0.31
Search in 300 million addresses with pg_trgm	0.00
jsonb LIKE query on nested objects in an array	+0.33
How do I unnest an array inside a function?	-0.05
Select column from table with condition in other table	0.00
PostgreSQL crosstab() alternative with CASE and aggregates	+0.29
ON CONFLICT ON CONSTRAINT trigger from any constraint	0.00
Dynamically build a variable and use it in a query in a plpgsql fun...	-2.79
Either of two SQL tables have a value	+0.37
Loop on rows produced by SELECT - looping variable does not exist?	0.00
Algebraic Data Types in Postgres	-1.11
Product of elements with same index in 2 arrays	0.00
Superuser expired and is the only user	0.00
Use computed columns more than once in same query	-0.19
Exclude timestamps in given interval on given days of the week	+1.34
Syntax error at or near ","	0.00
Return all the rows for id's that have all three seq number pre...	-2.36
Bind values for query with plpgsql in Yii2	0.00
Insert and associate repeated data in table	0.00
How to restrict values in a column based on values from another col...	-0.19
Fill a variable with "array_to_string" in a plpgsql trigg...	+0.29
Select rows based on comparison with other rows in same view	-0.41
Pass array of tags to a plpgsql function and use it in WHERE condit...	+0.74
Find next consecutive row by order_num field	0.00
Use something like TOP with GROUP BY	+1.59
Select well spread points from a big table	-0.88
Limit number of results from array_agg	+1.37
Error in creating function in postgres	+1.44
Optimizing a postgres similarity query (pg_trgm + gin index)	0.00
Why does Postgres not use better index for my query?	0.00
How to divide two values from the same column but at different rows	-2.39
Selecting unique identifiers with specific values	+0.49
How to add a leading zero when the length of the column is unknown?	+1.09
Date part in WHERE clause of a function	0.00
Selecting first N rows, where sum of lengths of TEXT field is up to...	0.00
PostgreSQL Trigger after update of a specific column	0.00
Database quering: GROUPing extracting first and last row	-1.64
generate_subscripts(array, 2) returns two records when there is onl...	0.00
How does postgres decide whether to use index scan or seq scan?	+1.79
Slow nested loop left join with index scan 130k times in loop	+1.40
Avoid checks for each row, replace query by function?	0.00
Test if anything was updated in dynamic query	0.00
Postgresql crosstab query with multiple "row name" columns	0.00