Reputation
47,073
Next tag badge:
98/100 score
43/20 answers
Badges
5 74 122
Newest
 Enlightened
Impact
~2.2m people reached

1h
answered Filtering UNION ALL result is much slower than filtering each subquery
4h
revised Can the subquery be simplified/optimized?
tags, trim noise, minor edits, format code
22h
answered Can the subquery be simplified/optimized?
2d
comment Extract string in PostgreSQL 9.2
but, that doesn't work - appears to be a bug in PostgreSQL AFICS. What does not work exactly? The function looks fine. (Except that all of this seems like overkill in the face of a simple split_part())
2d
comment Extract string in PostgreSQL 9.2
Just this: stackoverflow.com/a/8612456/939860
2d
revised Extract string in PostgreSQL 9.2
fix format
Apr
26
revised Optimizing queries on a range of timestamps (two columns)
typo
Apr
24
comment Prevent Update/Insert/Delete based on Date
Rules and triggers are possible solutions. Versatile, but also error prine. Table partitioning is probably cleanest: just revoke write privileges from partitions of your choice. Related: dba.stackexchange.com/a/106836/3684
Apr
24
comment Top N Results Ordered by Joined Table Column
Closely related: dba.stackexchange.com/questions/86038/… I guess it's a duplicate, not enough time to verify.
Apr
20
awarded  Enlightened
Apr
20
awarded  Nice Answer
Apr
20
awarded  Necromancer
Apr
19
revised Grant SELECT on all tables in Redshift
Typos, clean up
Apr
19
revised Grant SELECT on all tables in Redshift
typo
Apr
19
revised Grant SELECT on all tables in Redshift
edited body
Apr
19
answered Grant SELECT on all tables in Redshift
Apr
18
revised Calculating average with AVG for a list of numbers
wording
Apr
18
awarded  Nice Answer
Apr
18
revised Count children of a parent in recursive CTE
clean up
Apr
18
revised How to Pivot in PostgreSQL
added 20 characters in body