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 ... 23 24 25 26 27 ... 114

Title	Δ
How to get the average row number per rank in PostgreSQL?	-1.12
Execute a dynamic crosstab query	+1.21
Postgres GROUP BY, then sort	+0.05
Is there a way to select like with custom separator	+0.35
PostgreSQL CASE statement	0.00
How to group on part of a column in PostgreSQL?	-0.32
Get time interval between stop (row x) and start (row x+1)	-2.54
Dynamically define returning row types based on a passed given tabl...	0.00
Converting query result into CSV	0.00
How to ignore errors with psql \copy meta-command	0.00
Alternatives to broken PL/ruby: convert a warehouse journal table	-0.82
How to add a key to a JSON array value?	0.00
select or count from join table	0.00
Rank columns by their count of values	+1.79
Update composite type inside array	0.00
SQL Server - conditional aggregation with correlation	-0.15
Filter jsonb results in subselect	+0.32
order definition for comparisons in SQL ROW subqueries?	0.00
Postgres not using index for range query in partitioned table	-0.24
Query to count the frequence of many-to-many associations	+0.87
How to pass NEW.* to EXECUTE in trigger function	0.00
Postgresql - Function that generates random phone number	+1.31
How to use a subquery as a database name in a DDL command?	0.00
Why does a slight change in the search term slow down the query so...	+0.98
Postgres Converting Data Types	-2.08
How to display rows happening every week of a year?	-0.72
Creating optimal graph relation in PostgreSQL	0.00
Reason: PreparedStatementCallback; bad SQL grammar	0.00
Malformed array literal when selecting into custom type within a po...	0.00
syntax error when calling plpgsql function	+0.31
Best performance in sampling repeated value from a grouped column	+0.30
SQL where joined set must contain all values but may contain more	+0.31
Error: No function matches the given name and argument types	-0.52
How to guarantee that at least N rows are returned by recursive CTE...	-0.34
How to derive a column name in the return type from input parameter...	0.00
plpgsql : how to reference variable in sql statement	0.00
Get Id from a conditional INSERT	+1.64
PostgreSQL Index on JSON	0.00
Can INSERT [...] ON CONFLICT be used for foreign key violations?	0.00
Function parameter anyelement, PostgreSQL bug?	-0.20
Error when setting n_distinct using a plpgsql variable	0.00
Aggregating the most recent joined records per week	+0.84
Preserve PostgreSQL schema identifier in dependent function calls	0.00
Syntax for array of nested composite type without using ARRAY[]	-1.94
Correct syntax for array of composite type	-1.97
Why does 'now()'::timestamp return the current timestamp in...	-2.06
How to include excluded rows in RETURNING from INSERT ... ON CONFLICT	0.00
How to group multiple subqueries in the same output row	+0.86
How to determine the auto-generated primary key used as a foreign k...	0.00
PostgreSQL: create two functions or add a parameter to an existing...	0.00