Reputation
19,793
Next tag badge:
91/100 score
20/20 answers
Badges
6 55 104
Impact
~2.4m people reached

2d
awarded  Popular Question
Apr
21
comment How to display a number with fixed number of digits before the decimal?
@cartbeforehorse try to_char(123.56,'fm0999.99'), or perhaps you want to space pad on the left?
Apr
21
comment Is there a way to access temporary tables of other sessions in postgres?
"When temp tables are dropped, do they need a vacuum" no, see here. Same is true for any tables, not just temp tables.
Apr
19
awarded  index
Apr
18
awarded  Nice Question
Apr
4
awarded  Yearling
Mar
29
awarded  Nice Answer
Mar
28
awarded  Notable Question
Mar
26
awarded  Notable Question
Mar
21
awarded  Famous Question
Mar
7
awarded  Nice Answer
Jan
22
awarded  Popular Question
Jan
22
comment Extract ID String - PostgreSQL 9.2
Lucas please ask a new question about duplicates if you still need help with that, but not before this on is reopened. It is still very hard to understand, for example /userfiles/account/5554/attachment/26687981/file/2790000/main.with_name/photo.j‌​pg has 9 elements and /userfiles/account/(accountid)/(filecontext)/(ownerid)/(variation)/(filename) has 7, why is that?
Jan
1
revised What's the difference between data definition language and data description language?
fixed link
Dec
30
revised Normal form definitions
editied in summary from post
Dec
29
revised Migrate Jira to MySql - Unknown system variable 'storage_engine'
edited in content from link
Dec
20
awarded  Favorite Question
Dec
13
revised How do I install postgresql in Ubuntu?
removed section about postgres-xc after editing question
Dec
13
revised How do I install postgresql in Ubuntu?
removed red herring about postgres-xc
Dec
13
revised How do I install postgresql in Ubuntu?
fixed as per now-deleted answer (which should have been a comment on this answer)