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 ... 11 12 13 14 15 ... 114

Title	Δ
how to select postgres rows where at least one json element matches...	+1.40
PostgreSQL sequence connects to columns	0.00
Field is not populated by trigger AFTER INSERT	0.00
How to JOIN a JSONB column with an array by a text column?	0.00
First values in an auto increment trigger	0.00
How to avoid infinite loop with triggers between databases using po...	0.00
How to get first and last element per device?	+1.57
Cannot drop PostgreSQL role. Error: `cannot be dropped because some...	+0.31
How to use comparison where operator for JSON	0.00
How to distinguish conflict in sqlalchemy INSERT…ON CONFLICT (Upsert)	+1.27
Why do we need template0 and template1 on postgresql?	0.00
count max values in postgresql	-2.61
Why does creation of the following prepared statements fail?	0.00
What is the difference between a prepared statement and a SQL or PL...	0.00
SQL subquery to fetch rows by column values	+1.30
Why can PL/pgSQL functions have side effect, while SQL functions ca...	+1.28
How to use regexp_matches() in an UPDATE statement?	+1.71
Dollar-quotes failing with JDBC	0.00
Do all groups have equal total power for given subgroup?	+1.22
How to model diamond like many-to-many relationship in database ERD	0.00
Select only groups where all elements of group have same value	-1.17
Query to get user count for every month and previous month	-1.45
Is it necessary to use all 3 foreign keys as primary key in an asso...	+1.66
How to use generate_series() to generate a grid of values	0.00
"INSERT INTO ... FETCH ALL FROM ..." can't be compiled	0.00
Group similar rows and count groups in PostgreSQL	-1.13
Multiple ALTER TABLE ADD COLUMN in one SQL function call	-0.63
Index to query sorted values in keyed time range	0.00
SQL: Find the longest date gap from multiple table	-0.10
Update key value in jsonb array of objects	+0.30
How do I exclude from array in postgresql?	0.00
Query with dynamic target columns	0.00
Postgresql ADD SERIAL COLUMN IF NOT EXISTS still creating sequences	+1.60
Parse a JSON column with a FOR loop for every record?	+0.31
PGAdmin / Postgres : Cannot write Timestamp data to Postgres (2018-...	0.00
Function to select existing value or insert new row	-2.75
To sort the letters in a string alphabetically in PostgreSQL	-0.66
Query with UNION or OR?	+0.67
How to aggregate data from multiple years on MM-DD, ignoring year	0.00
Return default rows from a function when first SELECT does not retu...	-2.74
Extract date from datetime and calculate total minutes from duration	+1.64
How to check 'any or limited' in the WHERE clause of a query?	-0.81
Calculation in nested plpgsql function slower than in query directly?	-0.43
Properly handle TIME WITH TIME ZONE in PostgreSQL	0.00
How to force postgres to use columns order from csv when dumping/re...	+1.06
How to get average values for time intervals in Postgres	0.00
Slow LEFT JOIN on CTE with time intervals	0.00
"Syntax error at or near ' , '" while trying to S...	+1.52
How to optimize a SQL query that combines INNER JOINs, DISTINCT and...	+0.29
Check existence of given text in a table	0.00