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 ... 32 33 34 35 36 ... 114

Title	Δ
Limit number of rows per group from join (NOT to 1 row)	+1.86
Does PostgreSQL self join ignore indexes?	0.00
How to pass a parameter into a date function	+1.64
Select first record if none match	+0.39
How to use dynamic column names in an UPDATE or SELECT statement in...	-2.51
Check if key exists in a JSON with PL/pgSQL?	+0.35
Are these two PostgreSQL functions equivalent? (RETURNS TABLE and R...	-1.67
Query and order by number of matches in JSON array	+0.38
How to filter the max value and write to row?	0.00
GROUP BY in Postgres - no equality for JSON data type?	0.00
PostgreSQL - get all integer digits from double precision field for...	0.00
Compare two tables in postgres	-2.71
PostgreSQL inner queries with prepared statements	0.00
Partition pruning based on check constraint not working as expected	0.00
Prevent duplicate values in LEFT JOIN	+0.79
PostgreSQL select max with group by and additional value	+1.87
Stored procedure syntax with IN condition	+1.91
Execute multiple functions together without losing performance	+0.46
Could not connect to database postgres: FATAL: role"_postgres&...	0.00
How to write a function using arrays as input parameter in postgres...	0.00
Is there a shortcut for SELECT * FROM in psql?	0.00
Slow query with distinct/group by on varchar column with Postgres	+0.36
OVERLAPS operator to check multiples rows	0.00
Postgres superuser is getting permission denied to objects it does...	0.00
Fastest way to PostgreSQL Distinct and Format	-1.79
Simpify PL/pgSQL function with lots of if-else statements and JSONi...	+1.62
Update column to a value in joined column	+0.33
Bulk UPDATE table with WHERE clause that is variable	0.00
SQL query returning two of each record	0.00
Postgres UPDATE FROM set value according to result of other query	0.00
Safe way to open cursor with dynamic column name from user input	0.00
How to test my ad-hoc SQL with parameters in Postgres query window	-1.45
Why does a PostgreSQL SELECT query return different results when a...	0.00
Select max record of each group on a group by	+0.56
Use DEFAULT or INTEGER value as a SQL function's argument	-1.00
PostgreSQL multiple nullable columns in unique constraint	+0.57
Improve query efficiency for repetitive queries	-0.14
PostgreSQL Function Returning Table or SETOF	0.00
SQL workaround to substitute FOLLOWING / PRECEEDING in PostgreSQL 8.4	+0.89
match a string from a list of values and create new row	-2.21
Endless loop in trigger function	0.00
Execute String Postgres	0.00
Postgres - PivotTable/crosstab with more than one value column	0.00
Join cartesian product	-2.29
Fetch results on the basis of date from db without considering time	-0.40
Searching for any word or part of it inside string	-0.65
Change a date range into new rows with discrete dates	-2.56
Postgres - remove element from jsonb array	0.00
Minimum number of rows per group	+1.66
Autoincrement attribute based on another attribute	+1.47