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 ... 71 72 73 74 75 ... 114

Title	Δ
How to get the date and time from timestamp in PostgreSQL select qu...	+1.20
Postgresql and unicode table names: Why can I not select the table...	-2.55
Test for is null or = value in function	+1.04
How to reduce index scan time for a postgresql IN query with ordere...	+0.30
Query on subquery that gets tables' names	0.00
How to Update SQL Query's Result in a separate column	0.00
Compare varchar with char	0.00
Postgres 9.x Joining on Overlaping Date & Time Range	0.00
LIKE match string ending with a number	+0.31
How do I use the MAX function over three tables?	-0.87
Filter 2-dimensional array	0.00
SELECT DISTINCT and TRIM on the fly	-0.16
Concatenating strings in PosgreSQL result	-2.19
postgresql: counting business hours between time stamps	-2.74
Using sql function generate_series() in redshift	+1.27
SQL joined by last date	-0.47
Retrieving a user's conversations together with last sent and recei...	-2.81
Select finishes where athlete didn't finish first for the past 3 ev...	+1.89
Running complicated sql query within CASE	0.00
How to return multiple rows from PL/pgSQL function?	+1.42
ON DELETE CACADE is very slow	0.00
Removing COMMENT ON from all objects in PostgreSQL	+0.31
How can I sort the postgres column with certain special characters?	-0.36
Sum a sequence of device-labeled, data using most recent data for d...	+1.58
Sum across partitions with window functions	0.00
What's the easiest way to represent a bytea as a single integer in...	+1.19
Randomly select rows with chance depending on order?	-1.48
Ignore special characters in the WHERE clause	+0.31
dense_rank() order by and nulls - how to make it treat them as bott...	0.00
PostgreSQL 9.X bytea representation in 'hex' or 'escape' for thumbn...	0.00
SQL count more than 1 value accross multiple tables	+0.34
Force Postgres shift to uppercase rather than lowercase before sort...	0.00
PostgreSQL Domain: no numbers	+0.31
Upsert with a transaction	0.00
Idempotent INSERT not working as expected. Is my query logic faulty?	0.00
Need help understanding a complex query with multiple join conditions	+1.34
Passing in literal array to PostgreSQL function	0.00
How do I insert into a table from another table by matching on valu...	+0.31
Using INTERSECT with tables from a WITH clause	0.00
Check for complete duplicate rows in a large table	+0.30
Get functions DDL command	0.00
Adding a multi-column primary key to a table with 40 million records	+0.31
Array aggregation for all columns in a table in Postgres	0.00
PostgreSQL clever use of ST_Within	0.00
Big Integers and Custom Validation	+0.66
Change values before insert into table / PostgreSQL	-0.19
How can I express 24 hour time as 12 hour time when using timestamp...	0.00
Generate series of months in a column at postgresql	-0.68
Insert missing month in series in postgresql	-0.41
Converting a script from MSSQL to PL/pgSQL	0.00