Reputation
17,194
Next tag badge:
score
answers
Badges
4 44 88
Impact
~1.5m people reached

May
17
comment postgresql: How to pass jsonb to user defined C function and process it
Also, if your "C skills aren't the best either", I'm not sure you should be embarking on this adventure: here be dragons
May
17
comment postgresql: How to pass jsonb to user defined C function and process it
no, it's being cast, not converted. how would C know how to convert pg's binary notation - C has no knowledge of how pg's datatypes are stored internally. Try with json.
May
17
comment postgresql: How to pass jsonb to user defined C function and process it
Yes you can use it, but the question is what is cJSON_Parse expecting as a parameter? I don't think its expecting pg's binary encoding for JSON.
May
17
comment postgresql: How to pass jsonb to user defined C function and process it
My C knowledge is close to non-existent, but are you sure you should be using jsonb rather than json? Aren't you assuming in your code that it is a string representation rather than binary?
May
17
comment I'm having problem with System Time and the date where the System Date will stop and appear a Msg Box
I agree that your question would be a better fit on SO, but you also need to make it clearer before posting there.
May
17
reviewed Approve I'm having problem with System Time and the date where the System Date will stop and appear a Msg Box
May
17
comment Oracle: starter database?
@JustinCave "...If you created a starter database during the installation..."
May
16
comment Oracle: starter database?
have you tried connecting to it?
May
16
revised Improve the insertion rate of mongo sharded cluster
added 1 character in body
May
16
comment Replacing the results of a row
is db.table.name supposed to be db.student.name?
May
16
revised Replacing the results of a row
edited tags
May
15
comment Getting an aggregate (here: min) for a group of values
It doesn't solve the problem that the OP hasn't specified how he wants ties broken though ;)
May
15
answered Getting an aggregate (here: min) for a group of values
May
14
revised What does it mean? ORA-06502: PL/SQL: numeric or value error: character string buffer too small
edited tags
May
13
awarded  Popular Question
May
13
asked Why does the CBO eliminate `distinct` and not `group by` in this query?
May
11
revised Moved Model Database and now my SQL Server doesn't work
copied in a summary of the useful blog post - the alternative is deleting the answer, we aren't a link farm.
May
7
comment Moving a date between tables is causing error ORA-01841
Ah, I see. That would be a reasonable enough thing to do (except typos would result in exceedingly hard to find bugs) but no RDBMS I know of does that. Much better would be for an error to be returned unless columns are specified - that'd prevent all sorts of issues like this.
May
7
revised App domain is marked for unload due to memory pressure
added 89 characters in body
May
6
comment Moving a date between tables is causing error ORA-01841
How did you expect Oracle to know what columns were the 'right' columns if you didn't make it explicit? You should always, always, include the column names in an insert.