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 2 3 ... 114

Title	Δ
PostgreSQL: Convert UUID into OID	0.00
Ambiguous column reference in INSERT ... ON CONFLICT DO UPDATE	0.00
How to pass an array of integers to sql IN() query	+0.77
Can PostgreSQL use FOR LOOP in ORDER BY?	0.00
Select minimum value from each 1 hour block	0.00
Counts from another table don't exist yet to filter in WHERE	-0.44
Get associated properties as array - where a given property exists	+0.29
Indexing a JSONB key in combination with other columns	0.00
Faster search by indexing timestamp column on postgresql?	0.00
How to SELECT TO_CHAR with list {11:00:00,12:00:00}	+1.55
Count devices per day in a given date range	0.00
Reverse a column in postgres	-2.66
Given a set of IDs, Return the Subset of Orders with only those IDs	+1.32
Find if a string is in or not in a database	+1.59
Test ARRAY whether it contains ALL or NO elements of given ARRAY	+1.79
Conditional update with jsonb_set()	0.00
How to grant EXECUTE permissions for yet to be defined functions	0.00
Keep track of active objects over time	+0.30
Dropping Postgres schema inside plpgsql function after RETURN QUERY...	0.00
UPDATE with jsonb_set() only affects one object in nested array	0.00
How to get all data post midnight of different timezone?	0.00
Querying on items returned by STRING_TO_ARRAY	0.00
Table not found when creating Stored Procedure to insert data	0.00
SQL: Updating 2 different columns in table from CTE condition	0.00
How do you test for unmatched tables when using outer join (Many to...	+0.99
How can I use WITH together with IF in PL/pgSQL function	-0.12
How to shift whole groups in PostgreSQL?	+0.29
How to include the first row from the next group in an aggregation?	0.00
Getting counts for overlapping time periods	+0.30
How to execute "DROP OWNED BY" only if the user exists?	0.00
PostgreSQL optimize query performance that contains Window function...	0.00
Find the position of a string match	+1.95
PostgreSQL. Select a column that correlates with value in the aggre...	-1.67
Is it possible to select different rows each time without knowing a...	+0.29
SQLAlchemy with_for_update reads stale data	0.00
Trigger to ensure aggregate sum less than a value in a different ta...	+1.80
How to exclude rows with similar columns?	-1.20
Handling of generate_series() in queries with date or timestamp wit...	0.00
Unify columns from different tables while selecting distinct rows	+1.48
Postgres jsonb array join	0.00
Laravel - Calculations returning unexpected results with decimal/nu...	0.00
ERROR: column "int4" specified more than once	0.00
Calculate difference of multiple highest and lowest column values	+1.61
How do I use database defaults for input fields?	0.00
Return the row with max value for each group	+1.11
Postgres CROSSTAB Query not able to get all the expected Columns	-2.49
How to convert sql-text to jsonb-string?	0.00
How to identify rows per group before a certain value gap?	+0.75
Postgres: Select multiple columns and compare with array	0.00
How to make conditional LIMIT in SELECT query?	0.00