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 ... 24 25 26 27 28 ... 114
Title Δ
Create function with SELECT CASE +0.30
Operator ~<~ in Postgres 0.00
SQL Parameterized Query with Names instead of Question Marks 0.00
How to replace comma with apostrophe/single quote? 0.00
Selecting single and only single rows from GROUP BY -2.35
How to return multiple aggregates from a single query, all with dif... +0.58
How to pass table name to plpgsql function +0.34
What is PostgreSQL equivalent of INSERTING from Oracle? 0.00
Partial index on value from related table, rather than foreign key? 0.00
How to use variable as table name in plpgsql 0.00
PostgreSQL: out of memory issues with array_agg() on a heroku db se... 0.00
plpgsql return column name and column stats as a table 0.00
PostgreSQL crosstab query with data type mismatch 0.00
Confusion while using NOT IN clause in Postgres -1.76
PostgreSQL one to many pivot with crosstab +1.26
Confused about TIMESTAMPTZ internal conversion 0.00
Convert postgres array in csv dump to vector +1.79
Return constant literal from select query in postgresql 0.00
Getting a weird result for ISO Date in Postgresql -0.69
Replace ; with blank in SQL +0.25
Add text to field based on data from another table 0.00
JOIN (select ...) ue ON 1=1? -0.36
How to check if a table is empty and if so, check in another table? +0.98
How to split value using underscore (_) and period (.)? -2.63
Using EXCEPT clause in PostgreSQL 0.00
Extract numeric part from a string in PL/pgSQL -0.21
Select badges from table only if all requirements rows exist +1.44
Multiple CTE in single query +1.70
In SQL how to select previous rows based on the current row values? -1.15
Updating integer column from jsonb member fails with: column is of... +1.10
How to delete many rows from frequently accessed table 0.00
Replace rows from another table -2.77
How to use stored procedure returning boolean in IF-THEN-ENDIF cond... -0.58
GROUP BY isn't working as expected +1.34
Posgresql field timestamp without timezone - how to check if it equ... +0.31
Is there any shortcut to declare several variables of the same type... 0.00
Django/PostgreSQL varchar to UUID 0.00
How to convert keyvalue to columns, without using coalesce()? +1.29
PostgreSQL IF statement won't accept parameters 0.00
Purpose of uploading a schema file 0.00
PostgreSQL query for a list of allowed values in a constraint? -2.16
Assign a case value to a column rather than an alias +0.87
Select query with missing rows or zero values? 0.00
Prevent usage of index for a particular query in Postgres 0.00
SELECT fields from one table with aggregates from related table +1.45
Optimizing SQL query with multiple joins and grouping (Postgres 9.3) +1.19
Postgres - Loop through a string entry and create join table -2.73
Count not-null columns in row +1.39
Unescape a string with escaped newlines and carriage returns 0.00
SQL constraint to check whether value doesn't exist in another... 0.00