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 ... 85 86 87 88 89 ... 114

Title	Δ
Best practice to check if a variable exists in plpgsql?	0.00
PG::Error: ERROR: function left(character varying, integer) does no...	0.00
Find possible duplicates in two columns ignoring case and special c...	+1.05
SET SESSION AUTHORIZATION and the search path	0.00
Humanized or natural number sorting of mixed word-and-number strings	+1.47
Postgres function with list argument and in clause	-2.17
Fetch number of records on date in PostgreSQL while considering tim...	0.00
When this query is performed, do all the records get loaded into ph...	-1.37
SQL query where all A's must have the following coumns from B that...	+0.29
Index for a WHERE clause with datetime, and more	+0.30
Postgresql count+sort performance	+0.20
Faster search for records where 1st character of field doesn't matc...	+0.37
Order BY turns a 30ms query into a 7120ms query. Known performance...	+1.31
Table A references table B, how do I insert (using Perl and DBI and...	+0.30
Postgres SQL function string_to_array	+0.29
Find out which schema based on table values	+1.52
How to write Postgres query when filtering a column based on two co...	+1.32
SQL JOIN table with a date range	+0.31
Efficiently Subsample Timeseries Data in Database	0.00
How to tell PostgreSQL not to verify datatype	0.00
Using two different rows from the same table in an expression	+1.88
How to include null values in `tablefunc` query in postgresql?	-0.84
Dynamically generate columns for crosstab in PostgreSQL	0.00
Compare arrays for equality, ignoring order of elements	-2.15
Update multiple rows in a table from another table when condition e...	0.00
Copying Rows of Table0 to Table2 Where Same Rows Do Not Exist in Ta...	0.00
How to find dependent procedures on a table in PostgreSQL	0.00
using cross tab and pivot table function	0.00
SQL: Ignore some returned rows, deleting others	+0.77
How to delete a tree node and its childs records from a table (with...	0.00
How to check if a row exists in a PostgreSQL stored procedure?	+1.87
How to index a postgres table by name, when the name can be in any...	-1.40
Updating data in subquery	-0.21
Query using ILIKE with IN	0.00
Postgresql 9.2 trigger to log changes to data in another table	0.00
Change varchar to boolean in PostgreSQL	+0.30
PostgreSQL delete all but the oldest records	+0.18
How to export specific records from a postgreSQL Table as Insert SQ...	-0.25
PL/pgSQL CREATE or REPLACE within EXECUTE	-0.69
case with regexp: set-valued function called in context that cannot...	-2.17
Sanitize input to a column in postgres	0.00
Check if records exists in a Postgres table	-0.85
how to make join table update efficient in sql (it's efficient from...	+2.05
PostgreSQL: List dependent rows	+1.10
Grouping the results of a query with CTEs	0.00
How to order these SQL results in a certain way?	+0.02
Truncate timestamp to arbitrary intervals	+1.48
Passing a record as function argument PL/pgSQL	0.00
Keeping rows from double-counting in a GROUP BY	+1.14
SQL Query timestamp date field and group all results by date	-0.70