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 ... 28 29 30 31 32 ... 114

Title	Δ
Select rows where the last row of associated table has a specific v...	+0.78
Crosstab transpose query request	0.00
How to access data in a Postgres hstore field and sum from Active R...	0.00
How to query row with max value in a column in a referencing table?	+0.73
Merge multiple result tables and perform final query on result	0.00
Select truncated string from Postgres	0.00
Indexing jsonb data for pattern matching searches	+1.36
How to correctly associate an id generator sequence with a table	-0.67
SQL syntax term for 'WHERE (col1, col2) < (val1, val2)'	+1.33
Update Postgres Counter Cache with pure SQL	-0.13
Joining a Temp Table to Actual Table	+0.32
How to merge 2 queries together in same query but different columns?	0.00
Pattern matching on jsonb key/value	0.00
ORDER BY changed column with same name	-1.23
Crosstab function in Postgres returning a one row output when I exp...	0.00
Declare row type variable in PL/pgSQL	0.00
Get records for last 10 dates	0.00
Any way to speed up this sql query?	0.00
BEFORE Trigger + RETURNING returns NULL	0.00
Expand JSONB into columns with first row as template	0.00
SELECT query that uses data from another row	-0.23
Terminate all connections from specific schema in certain database	0.00
Rails - Distinct ON after a join	+0.31
Get substring from a column with delimiter and varying number of el...	0.00
Race condition using Postgres hstore	0.00
Find most occurring Col3 for every pair of Col1 and Col2	+1.82
Get the count of rows count after GROUP BY	0.00
PostgreSQL: No function matches the given name and argument types	-2.26
How to check a sequence efficiently for used and unused values in P...	+1.29
Copying timestamp columns within a Postgres table	+0.04
How to use query created in stored procedure in other procedure	-2.54
Count by association: syntax error at or near "AS"	-1.39
Subquery that matches column with several ranges defined in table	0.00
UPDATE with a join not working	-0.18
How do I query all rows within a 5-mile radius of my coordinates?	+0.89
Revoking access to database does not seem to work	+2.02
Efficiently determine if any rows satisfy a predicate in Postgres	-2.48
Better way than multiple SELECT statements?	+1.15
Explanation of code for right excluding join?	-0.17
postgresql - are my indexes or column types slowing down my query?	0.00
How list all tables with data changes in the last 24 hours?	0.00
Get all records matchung some conditions OR at least 10 by adding s...	+1.14
Calculate table column using over table on server side	+0.33
How can i enter varchar values in case if the field type is integer...	+1.33
Add cumulative total sum over many columns in Postgres	+1.77
Cumulative sum of values by month, filling in for missing months	0.00
Dynamically access column value in record	0.00
Will changing column from timestamp to timestamptz lock the table?	0.00
Group by end of period instead of start date	0.00
How do I drop a very specific table in Postgresql (public.pg_ts_par...	0.00