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 ... 67 68 69 70 71 ... 114

Title	Δ
Insert multiple rows in one table based on number in another table	0.00
how to introspect materialized views	+0.31
Get result from query in DO satement	-0.17
SQL join 1-many querying only parent rows without duplicates	0.00
Postgres: "Recursive" query with Array	-0.26
SQL to return one resultset from multiple tables when either table...	-0.40
Slow handling of 2-dimensional arrays in plpgsql	0.00
How to create alias from all columns in sql?	+1.28
How to loop through split string	-2.42
How to join many to many relationship on max value for relationship...	-0.14
Return list with dates within a specified range from a single query	0.00
Postgres - Replacing variety of names in a column for a respective...	-0.97
Count the number of occurrences grouped by some rows	-2.98
Construct a geometry type from two numbers	+1.32
Select records based on last date	+0.63
Add privileges to group role without knowing schema name	0.00
Performance impact of empty LIKE in a prepared statement	0.00
Import XML files to PostgreSQL	+0.32
PostgreSQL drop table command is not reducing DB size	-0.68
PostgreSQL - GROUP BY clause	+0.33
Select column name and value from table	0.00
Optimising Select number of rows in PostgreSql for multiple group b...	0.00
Why does the following join increase the query time significantly?	+0.78
PostgreSQL multiplication of columns	+0.30
Left outer join acting like inner join	+0.32
Data type error on prepared execution plan	-0.29
Postgres return a default value when a column doesn't exist	+0.33
Refreshing a materialized view does not include added column	0.00
case sensitve query returns string instead of list	0.00
Create a multicolumn index to enforce uniqueness	0.00
Parameterize table name for cursor bound variable	0.00
how to convert "string" in to "timestamp without tim...	0.00
plpgsql expert : (set of record) input and output for a function	+1.27
Poor performance on a PostgreSQL query	+0.33
Create a temporary table from a selection or insert if table alread...	0.00
SQL Select Query - "Pairing" Records Together	-0.45
UNION ALL on Json data type	0.00
Querying inside Postgres JSON arrays	-0.66
Indexed ORDER BY with LIMIT 1	0.00
Update record of a cursor where the table name is a parameter	0.00
SELECT statement returning unqualified column names	-0.49
Postgres hangs on large table when trying to update multiple rows w...	+0.34
Aggregate SQL group by counts based on group by	-0.28
Make faulty PL/pgSQL functions fail during creation (not on first c...	0.00
How to use query result in next query inside Postgres transaction?	0.00
Syntax error for insert query alias in Postgres	-1.63
Group by floating date range	-0.76
Maven version ordering	0.00
Postgres Exception - Internal Statement is right but Query Fails	+0.36
Compare interval date by row	+0.95