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 ... 35 36 37 38 39 ... 114

Title	Δ
Escaping a LIKE pattern or regexp string in Postgres 8.4 inside a s...	+1.36
Delete duplicate rows from table with no unique key	+0.62
String matching in PostgreSQL 8.4	+1.30
Tricky PostgreSQL join and order query	-0.16
Get unique pairs from self-join, plus rows without a match	0.00
Row number from one column, but then re-order using another column	-1.34
DISTINCT ON query w/ ORDER BY max value of a column	0.00
Rounding of the numeric values	0.00
Generating unique combinations in postgres of size two from an array	-2.71
How to add a user to PostgreSQL from the Ubuntu command line?	0.00
Simple update set postgres stored procedure	0.00
Get created as well as deleted entries of last week	+0.35
Find the lastest qualifying row for each key	+1.15
PostgreSQL transaction restart	0.00
PostgreSQL multiple tuples selection in WHERE clause	+0.76
Get count of created entries for each day	+0.57
Subquery or multiple queries in sql to get results	+0.34
How to prevent PostgreSQL from altering my nicely formatted SQL def...	+1.59
Is PostgreSQL multi-row insertion all or nothing?	0.00
Lock for SELECT so another process doesn't get old data	+0.36
Resolving an ambiguous column in a subselect	-1.28
How to limit result set with multiple RETURN QUERY in postgresql	0.00
SQL query checking columns in first table or looking up rows in sec...	0.00
pgAdmin: How to see complete value in a cell in output	0.00
Combine the most recent entries from a number of tables	-1.20
Postgres function optimisation	+1.66
Function taking forever to run for large number of records	0.00
SUM & GROUP BY on an array of composite type	0.00
PostgreSQL: deleting rows referenced from another table	+0.83
PostgreSQL 9.3: Union two columns in one	0.00
How to return a value from a function if no value is found	+0.33
UPDATE order in PostgreSQL	0.00
Get distinct individual column values (not distinct pairs) from two...	-0.25
Numeric Precision Rounding Artifacts with PostgreSQL	0.00
How to cast entity to set in PostgreSQL	0.00
Improving performance with a Similarity Postgres fuzzy self join qu...	0.00
Query returning too many results	+2.13
INSERT INTO ... FROM SELECT ... RETURNING id mappings	+0.31
PostgreSQL 9.3: Display result in specific format using array_agg f...	+1.20
Can someone give examples of use case of the ordered-set functions...	0.00
GROUP BY is creating multiple rows instead of 1	-0.15
Query failed: ERROR: invalid byte sequence for encoding "UTF8&...	-1.66
Compound index with three keys, what happens if I query skipping th...	+1.35
Left Join with Group By	-1.23
How to export a PostgreSQL query output to a csv file	0.00
Counting distinct rows using recursive cte over non-distinct index	+1.27
What is the performance of arbitrary ordering in PostgreSQL?	0.00
Number of palindromes in character strings	0.00
Create a unique index on a non-unique column	0.00
Passing parameters gives array error in Postgres 8.2 function	-0.15