Reputation
17,539
Next tag badge:
93/100 score
20/20 answers
Badges
4 45 91
Newest
 Good Answer
Impact
~1.6m people reached

Jun
6
revised Modify LISTAGG query for 10g
edited tags
Jun
6
comment Postgresql CRUD operation on Single json data row
It might be good to relegate the 9.4 info to a footnote as the OP says "I cannot use jsonb..."
Jun
6
comment Postgresql CRUD operation on Single json data row
also, are you actually doing CRUD or just querying? The answer below offers a way of updating json but not querying the way you want.
Jun
6
comment Postgresql CRUD operation on Single json data row
Presumably there is a good reason why this data is in json at all rather than in a table?
Jun
4
comment Mongo Shard with Negative Average Size?
+1 for coming back and sharing your solution - I'm closing the question because it now looks too localized to be of help to future visitors.
Jun
1
answered Use of hash functions in group by?
Jun
1
revised How to load data into Vertica from C?
as suggested by Kermit: http://chat.stackexchange.com/transcript/message/21956047#21956047
Jun
1
revised How to resolve error ORA-19802 when starting up an Oracle database instance?
deleted 28 characters in body
May
29
comment SELECT DISTINCT on multiple columns
"it requires 4 scans of the table (and no index is used):" -I'm surprised, I'd thought it might do 4 full index scans as they are covering and smaller than the table. Maybe it doesn't because there'd potentially be more physical io if the indexes aren't already in memory.
May
28
revised SELECT DISTINCT on multiple columns
added 38 characters in body
May
28
answered SELECT DISTINCT on multiple columns
May
27
comment Copy a large data from sql query result
This has been flagged as 'spam', probably because it's your only post and it's promoting your own product. I'm not deleting the answer because I think it's a genuine attempt to help (and CSV can easily be imported into Excel), but please have a read of the meta Q&A on "What is acceptable self-promotion here on DBA.SE"
May
26
comment How to solve UTF8 invalid byte sequence copy errors on a restore, when the source database is encoded in UTF8?
OK, but the OP says "the original database is in UTF8" - interesting info about unicode, have you got a link by any chance?
May
26
revised How to select the first row of each group?
http://chat.stackexchange.com/transcript/message/21831139#21831139
May
26
awarded  Popular Question
May
25
awarded  Nice Answer
May
25
revised How to select the first row of each group?
tweaked
May
25
revised How to select the first row of each group?
rolled back to a previous revision
May
25
revised How to select the first row of each group?
rolled back to a previous revision
May
25
revised How to select the first row of each group?
simplified by removing the more complex example - this is now really the canonical way of doing this