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 ... 7 8 9 10 11 ... 114
Title Δ
Other way to cast varbit to int? And bigint? 0.00
Enforce relationship via a foreign key constraint? +2.41
Search for sub-string that start with some characters and replace t... 0.00
Is there a way to replace the first '/' from a string condi... +0.28
Cumulated sum based on condition in other column +2.46
Test column for special characters or only characters / numbers +1.62
How convert recursive to function in plpgsql? +0.32
Cast to int instead of decimal? 0.00
How to update JSONB array based on property name? 0.00
How to use "where" clause with "order" condition 0.00
Convert a bytea into a binary string -0.23
Postgresql ignoring 'when' condition on trigger +0.32
How to create INSERT query that adds sequence number in one table t... 0.00
How to convert array with non-standard indexes to json? 0.00
Postgresql offset return same data 0.00
How to query based on max size of attribute in a JSON object array 0.00
How to gradually print SQL query results before the end of execution? 0.00
Get rows within last 30 days, excluding today +0.32
Dropping DB when there are active connections 0.00
Optimizing unioned inner joins? +0.32
PostgreSQL JSONB - Update key name on all rows with a single query 0.00
How to update a value inside nested arrays in a jsonb object? -0.17
Reusing the same moving window for multiple window functions 0.00
Set a temporary global variable during a Postgres query +1.40
Extremely slow distinct query on indexed column 0.00
How to reduce PostgreSQL database size? +0.32
Why is Bitmap Scan faster than Index Scan when fetching a moderatel... 0.00
How to store large currency like data in database 0.00
SELECT if string contains column value -0.01
PostgreSQL - How to cast dynamically? 0.00
Index scan for multicolumn comparison - non-uniform index column or... -2.77
Enforcing index scan for multicolumn comparison 0.00
Display result in one line 0.00
Calculate moving average using SQL window functions with leading nu... -0.15
How to add a PostgreSQL GIN index on a uuid in Postgres 9.6 0.00
How to get mode() in a window function in Postgres? 0.00
How do I improve date-based query performance on a large table? +1.60
Group results by date range +0.32
joining against a value list in postgres using node and pg-promise +1.42
How to search in array with LIKE operator -0.11
PostgreSQL crosstab doesn't work as desired +0.15
How to enforce by constraint that a referenced row also has a given... +0.31
select query joining two tables on a range +1.01
ELSE value not executed in CASE expression PostgreSQL 0.00
How to get the list of column names for all indexes on a table in P... +1.65
Changing data type to float and rounding to 2 decimal digits -1.98
Indexing strategy for different combinations of WHERE clauses incl.... 0.00
How to get date_part query to hit index? 0.00
Get max value from a window of rows as new column for all rows +0.25
Extract number of days per week from multiple date ranges -2.36