Reputation
16,865
Next tag badge:
400/400 score
80/80 answers
Badges
4 44 87
Newest
 postgresql
Impact
~1.5m people reached

5h
revised Is copy/rename a good way to improve temp table performance?
added 89 characters in body
5h
awarded  postgresql
5h
answered Is copy/rename a good way to improve temp table performance?
6h
comment Postgres Streaming Replication: How to re-sync data in master (with standby) after failover
@dezso I don't think it's ever possible to set the old master as a slave without restore/rewind.
6h
revised Postgres Streaming Replication: How to re-sync data in master (with standby) after failover
edited tags
6h
reviewed Approve Postgres Streaming Replication: How to re-sync data in master (with standby) after failover
17h
comment ODBC Problem ORA-1089 cause ORA-3114
Or better still, stop shutting the database down at all.
1d
revised Backup SSRS Encryption Keys Using Powershell
edited in script
May
1
comment PostgreSQL function definition “syntax error at or near +”
In which case I think the question needs to be 'put on hold' - it's kind of misleading as it stands and you've got your answer.
Apr
30
comment PostgreSQL function definition “syntax error at or near +”
I guess it is intentional - it helps when mixing top level EXCEPT and UNION for example.
Apr
30
comment PostgreSQL function definition “syntax error at or near +”
As mentioned in Craig's answer, your original query as-written returns an error too, so I'm not sure what you mean by "This query works great"?
Apr
18
awarded  Nice Answer
Apr
16
revised Mathematical equality of two SQL statements
tweaked phrasing to be more of an answer and less of a question. Added reference.
Apr
14
comment Does “deprecated” in MySQL means “not guaranteed” or “still guaranteed”?
The down-votes on this post reflect the communities disapproval of the manner in which the OP chose to disregard good advice given in the comments (now deleted, basically amounting to "just use ORDER BY anyway"). Please don't use comments for discussion or dispute.
Apr
7
awarded  Favorite Question
Apr
6
awarded  Notable Question
Apr
4
awarded  Yearling
Mar
13
awarded  Revival
Mar
11
revised How do I get the difference in minutes from 2 timestamp columns?
removed aside that could be taken as snark
Mar
5
comment Order by alphabet and then by numbers
Is substring(text,text) an undocumented variant of substring(string from pattern)?