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 2 3 4 ... 114

Title	Δ
How select data from two column in sql?	-2.20
How to remove duplicate rows with exact match in two columns?	-0.23
Casting issue in call of custom aggregate function in dynamic SQL	+1.37
Compute an aggregated tsrange from a set of entries?	-2.10
DEFAULT is not allowed in this context error	+1.60
In Postgres, how would I retrieve the default value of a column, pr...	+0.72
PL/pgSQL - Find out which items of an array exist in the table	-0.06
Best data structure to store long strings of digits	0.00
Multiple joins on the same table multiply counts	+1.45
How can I select all rows from different tables when the query retu...	+2.07
How to know which column has changed on UPDATE?	0.00
Don't round float input silently when inserting into integer co...	0.00
How to substitute a variable when creating a check constraint?	0.00
PostgreSQL's ILIKE query with conditional filtering	-0.83
SQL with multiple joins causing duplicates	-2.20
Using NOT EXISTS with a subquery	-1.89
PostgreSQL - Get count of items in a table grouped by a datetime co...	-2.46
Estimating size of Postgres indexes	+1.54
PosgtreSQL procedure	-0.71
How to apply lists of filter values on two columns in lock-step?	+0.29
How to build query with separate, identical WHERE conditions on mul...	0.00
Concat year and month but with a fixed size	+2.04
How to save the results of a select expression as a variable?	+2.05
Get values repeated over 2 minute period in Postgres	0.00
"wrong element type" when using JSONBArray using pgx	0.00
Function to add new column dynamically with ALTER TABLE	+0.31
Optimizing very slow PostgreSQL LEFT JOIN between two large tables	-2.71
Issue with importing formatted numbers over 1,000 with COPY	0.00
SQL Column Contains ID of Another Row	-0.74
How to count number of groups?	-2.38
I have three columns in SQL and I am trying to get all columns that...	0.00
how to convert string as sql syntax	0.00
Get apps with the highest review count since a dynamic series of days	+0.81
Read binary file with PostgreSQL without pg_read_file	0.00
Remove all Unicode space separators in PostgreSQL?	+2.50
search for cross-field duplicates in postgresql and bring back matc...	+1.19
How to respect the order of an array in a PostgreSQL select sentence	+1.60
How to add Foreign key constraint on array in PostgreSQL?	0.00
search for cross-field duplicates in postgresql	+1.67
Is CAST from integer to text collation specific?	0.00
What is wrong with the left join?	+0.30
GROUP BY error: column "f.path" must appear in the GROUP...	-1.40
Deadlock involving SELECT FOR UPDATE	0.00
One-to-Many SQL SELECT concatenated into single row	-2.01
Delete range of rows using generate_series()?	-2.37
Is there a better way to reconstruct a data from hundreds of millio...	-0.12
If my search term is not found add to array	0.00
Combine predicates on two joined tables with OR	-2.86
Passing Variable in to psql file via command line. One variable pas...	0.00
How to order SQL queries with conditionals?	-1.31