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 ... 21 22 23 24 25 ... 114
Title Δ
Joins around if statement for PostgreSQL trigger function 0.00
OUT parameters from plpgsql function are NULL in function, but show... 0.00
Optimizing a row exclusion query +1.35
"ERROR: column ... specified more than once" in VIEW defi... 0.00
Replace 'n/a' with 'NA' in all columns of a table 0.00
How to build relationships using data from two tables? -2.15
Trigger with dynamic field name -0.19
What isolation level should I use for workers pulling from a queue... 0.00
Daylight savings time for GPX and PostgreSQL 0.00
Query jsonb column containing array of JSON objects 0.00
How to split query result by data which may be present or absent in... 0.00
join of large tables with primary key +1.21
Add computed value as new column while also removing duplicates -2.07
Select people with latest balance for one credit card being greater... +0.29
Best data model to store small fixed-length array in Postgres (with... 0.00
postgres: concat string with array -0.18
Single update query from two ordered arrays 0.00
Set empty strings ('') to NULL in the whole database +1.14
How to convert text to jsonb entirely for a postgresql column -2.09
Return data aggregated by one column id and data-aligned to another... 0.00
Rolling counts based on rolling cohorts 0.00
PostgreSQL: How to select on non-aggregating column? -0.63
How to get back aggregate values across 2 dimensions using Python C... 0.00
Best way to get Static data inside before trigger +0.30
How to run plpgsql without creating a function? -0.26
How to include missing data for multiple groupings within the time... +1.63
How to pass the value of NEW using dollar quoting? +0.30
Update column to any non-unknown value of the column in another row... 0.00
Split function-returned record into multiple columns 0.00
Declare "LANGUAGE plpgsql" before or after the function b... 0.00
How can I accomplish the following in SQL? +0.62
How to filter available rooms in specific period 0.00
Count on join of big tables with conditions is slow +1.41
Handling quotes in COPY to CSV from command shell -0.70
How does recursive CTE work with example in the doc? +1.29
Use Values from JSONB Array inside a WHERE IN Clause 0.00
PSQL Command Line Arguments in DO script +1.19
Can PostgreSQL array be optimized for join? 0.00
Postgres timestamp with time zone saving with hour shift 0.00
How do I add a column to a date in Postgres? 0.00
PostgreSQL crosstab error -0.19
Get substring from regular expression - everything up to a character 0.00
SQL group table by "leading rows" without pl/sql +0.67
Error: column does not exist in PostgreSQL 0.00
PL/pgSQL to copy data from tables dynamically 0.00
PostgreSQL does not accept column alias in WHERE clause 0.00
SELECT * from simple table with 50k records seems to take 40 seconds -0.44
Combine two queries with monthly average -0.75
Join Postgresql tables on json array columns +0.32
"perform create index" in plpgsql doesn't run +1.15