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 ... 41 42 43 44 45 ... 114
Title Δ
Find the last item in a JSON array in Postgres 9.4 0.00
SQL table column values to select query list 0.00
How to reduce the costs of an sql select with order by? +1.97
Error: argument of HAVING must be type boolean, not type double pre... -1.59
Update column in multiple tables 0.00
Fetch similar rows based on tag intersection +0.41
Pass an array parameter on psql command line 0.00
Combined SELECT from unnested composite type array and regular column 0.00
Raw SQL queries in a REST Api -0.25
fetching compact version of JSONB in PostgreSQL 0.00
PostgreSQL Query Time -0.30
Grouping similar rows and counting other columns based on it in SQL 0.00
PostgreSQL function does not exist 0.00
Insert into table using for loop -0.13
Using crosstab to convert rows to columns fails +0.97
ERROR : The column index is out of range: 1, number of columns: 0 0.00
Index of all columns on PostgreSQL 0.00
Join rows with fuzzy time data to regular time slots -0.14
How to select inside a FOR-Loop for further computations? +0.38
How to mark certain nr of rows in table on concurrent access +0.07
Make postgres full text search (tsvector) act like ILIKE to search... 0.00
Extract year from date within WHERE clause +0.07
Insert data into empty cells in ascending order 0.00
Query over three tables -0.32
Error: "More than one row returned by a subquery used as an ex... 0.00
Same query, different table, different execution time on postgres -2.16
How to pass timestamps to a function and retrieve resulting rows 0.00
SQL INNER JOIN over multiple tables equal to WHERE syntax 0.00
PostgreSQL - string_agg with limited number of elements -0.01
How can I aggregate and collapse rows in a database table using SQL? -2.32
Given time/interval to calculate open/high/low/close value in each... -0.37
Regex to remove "-" from the middle of a timestamp string... +0.38
Query Postgres for number of items in JSON 0.00
Calculate average from JSON column 0.00
Duplicate key constraint error when inserting to empty table with n... +0.38
PL/pgSQL If Exists Display the result without a function -0.28
Query aggregated data with a given sampling time 0.00
Why is IS NOT NULL false when checking a row type? +1.30
Rails polymorphic association with multiple foreign keys and databa... 0.00
How to choose dates after a certain year in PostgreSQL +1.84
PostgreSQL get serial value from primary key to foreign key 0.00
How I can define this constraint? 0.00
Remove duplicate column after SQL query +0.39
How invoke PL/pgSQL from command line instead of SQL +1.34
Filter students that have not passed a subject yet +1.23
Simplify and/or optimize sql query with INTERSECT or HAVING +1.05
PostgreSQL Order By SubQuery +0.05
Creating a trigger for child table insertion returns confusing error -0.12
How to convert primary key from integer to serial? 0.00
Can PostgreSQL recommend optimal field types? 0.00