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 ... 6 7 8 9 10 ... 114

Title	Δ
Can postgresql stored procedures operate on a separate database?	0.00
Changing schema name within functions	0.00
Get combined row from multiple tables	0.00
Unexpected effect of filtering on result from crosstab() query with...	0.00
Unexpected effect of filtering on result from crosstab() query	0.00
SQL: "condition is not true" pattern as replacement for &...	+0.29
PostgreSQL: Grouping then filtering table, with condition for nonex...	-0.16
How to COALESCE different values in an UPDATE depending on whether...	0.00
How to apply a SQL update for a list of values?	0.00
Insert into Postgres table only if record exists	0.00
Change number of Rows Affected by Update	0.00
Complicated Crosstabbing in PostgreSQL involving Overlapping Dates	0.00
PLPGSQL how to use function parameters?	0.00
Finding all playlists that have a track with specific artist name?	+1.73
Transpose single row with multiple columns into multiple rows of tw...	0.00
Select first row each time column changes	+1.88
Call a function with composite type as argument from native query i...	0.00
How to UNION a list of tables retrieved from another table with a s...	+2.05
Concurrent select queries split by row ids Vs one query	+0.25
Why does this query need aggregate?	-2.43
Postgresql count row grouped by	0.00
Attribute notation for function call gives error	0.00
How to use BETWEEN condition for array column in Postgres?	0.00
SQL JOIN: add custom constraint in JOIN clause	+1.44
Properly extracting JSON arrays from a JSONB field	0.00
Postgres Subquery - How to create ALIAS in object format from subqu...	-0.72
How to use the NOW() function as upper bound of a range?	0.00
Duplicate column name merge in Postgres views	0.00
In plpgsql, return set of composite type without cast?	+0.32
Find the longest streak of perfect scores per player	+1.71
More than one path to JOIN the same table in Postgres	-0.16
Inconsistent results with jsonb_array_elements_text() twice in the...	0.00
With a many-to-many relationship, search by the many for the one	-2.56
Search for all records within X distance of any records in a table	0.00
How to concatenate two of the values of a JSON-array in a certain o...	0.00
Select for update query returns cardinality violation	0.00
Error from trigger function: ERROR: column does not exist	0.00
Apply all regexp_replaces from table sequentally to one string	0.00
UPDATE to remove duplicates from comma-separated list	-2.28
Test jsonb array to see if it contains one or more elements?	-0.18
Is there any way where I can do ALIAS reference other column value?	+0.53
Update Multiple Rows with Specific Values and Others With Zero	+1.67
Why count ignores grouping by	-0.26
Is there a way to speed up this multi-table query with indices?	0.00
count the number of an array	-0.23
Efficiently selecting distinct (a, b) from big table	+0.27
Optimising function which extracts records with a minimum gap in ti...	0.00
Query does not hit the index - are these the proper columns to index?	+0.32
Trigger \| how to delete row instead of update based on cell value	+0.32
Race Condition between SELECT and INSERT for multiple columns	0.00