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 ... 64 65 66 67 68 ... 114
Title Δ
PostgreSQL Unique Constraint with Exceptions 0.00
Check if any of a given array of values are present in a Postgres a... 0.00
How can I stop a postgres table from having duplicate record and in... 0.00
Trigger return new infinite loop 0.00
PostgreSQL sql-state: 42601 on SELECT INTO -2.28
ORDER BY lower case of output column -2.34
Aggregation function to get the difference or ratio of two rows in... -0.11
Preserve timezone in PostgreSQL timestamptz type +0.33
Add a column to a table in all schemas of a PostgreSQL database +1.61
How to get columns data types from arbitrary SQL select? +1.74
PostgreSQL dump and restore in different timezone 0.00
Generic bit string comparison against zero in Postgres 0.00
Behavior of update with left join +1.63
Error in plpgsql function: array value must start with "{"... 0.00
Query has no destination in a plpgsql function? -2.48
Retrieve last known value for each column of a row +0.42
Update query on big table slow +0.33
Query to ORDER BY the number of rows returned from another SELECT +1.68
Return type for function with array_agg() 0.00
PostgreSQL sum typecasting as a bigint 0.00
Variables for identifiers inside IF EXISTS in a plpgsql function -0.18
How to use array_agg() for varchar[] 0.00
Check Constraint Usage +0.28
Allow null in unique column +1.39
Update substrings using lookup table and replace function +1.60
Compound OR SQL query (query #1 with WITH) and (query #2) with COUN... +0.96
Allow insertion only from within a trigger 0.00
Unique aggregate function when singular value is guaranteed by the... -0.02
How to drop all NOT NULL constraints from a PostgreSQL table in one... 0.00
Allow only triggers to update a column 0.00
Loop through table and return a specific column -0.44
How to find whether unique key constraint exists for given columns +2.02
Return multiple values and populate column in array like manner -0.21
Error when trying to return from plpgsql function using RETURNING w... 0.00
Joined elements should *all* match some criteria -0.17
Rank based on sequence of dates +0.31
Writing an SQL trigger to find if number appears in column more tha... 0.00
Trigger to delete rows from related tables before deleting rows fro... -0.16
Find movies with highest number of awards in certain year - code du... -0.39
Select Distinct On while Order By a different column +1.61
Why can I create a table with PRIMARY KEY on a nullable column? +1.63
BLOB to Image conversion in PLPGSQL 0.00
getting categoryid fo more than one shortname passed 0.00
Add a subquery to SELECT statement that depends on the first column? 0.00
Select row by minimal distance 0.00
Missing FROM-clause entry for a table +2.08
How to UPDATE table from csv file? 0.00
How to concatenate columns in postgresql select? +0.31
Can I have parametrized SQLSTATE in exceptions in PostgreSQL 0.00
In Postgres, how can I average the latest 5 scores per user? 0.00