« first day (2026 days earlier)   

8:03 AM
-1
Q: Insert into the Table using PGSQL -- C lib -- Runtime

EduruI want to insert data into a table of a database using PSQL-- C interface I was able to do it in hard code manner as follows: res = PQexec(conn, "INSERT INTO t_name VALUES(c1_val,c2_val,…)"); But I am unable to do this: Assume my table has columns named price, id etc.., I want to ask the user...

I think it is a (poor) SO question
BTW, where is @JackDouglas these days?
 
8:18 AM
Looks behind the back of the sofa
 
Paging @Bluefeet
4

Pivot (topic request)

PIVOT rotates a table-valued expression by turning the unique values from one column in the expression into multiple columns in the output, and performs aggregations where they are required on any remaining column values that are wanted in the final output.
requested by Karthikeyan 209
Morning all
 
7
Q: Documentation beta

PhilI see that the Documentation Beta is now live. Is this going to get pushed to DBA.se at any point, or is it going to only live on Stack Overflow?

heh, community manager getting downvotes
 
8:38 AM
@Phil one was from me, to indicate my different opinion
 
 
2 hours later…
10:39 AM
I've voted to re-open this question, seeing as I'd actually answered it & it seems obvious what the OP needs: dba.stackexchange.com/questions/144460/…
 
10:52 AM
@Phil well, the wording does not help much
it is the it is deleted
also, what is functionality .os?
 
@dezso It shells out and executes a command
 
@Phil I've edited the Q, does it make sense now?
 
@dezso "…if yes it is , then it is deleted", I think
 
@AndriyM ah, probably
in any case, @Phil seems to answer this question :D
 
 
1 hour later…
12:03 PM
Welcome to the site. Good to see Oracle employees frequenting here! Cheers. — Phil 9 secs ago
 
 
4 hours later…
4:23 PM
it's like all of our software vendors have conspired to say, "hey. let's blame index fragmentation!"
 
 
2 hours later…
6:07 PM
Yeah, I wasn't sure what to make of that comment (which has been removed). It felt somewhat inappropriate, even though it was overall complimentary.
And thank you very much for posting that bounty. That was very kind of you and I certainly appreciate it 😺.
 
 
1 hour later…
7:16 PM
@srutzky i can downvote your answer if it assuages your guilt
 
7:30 PM
@swasheck Well, that is definitely kind of you to offer, thanks. However, I wasn't really feeling guilty about anything ;-). But, I will keep your offer in mind for a time when I am in need of it, if that's ok with you.
 
8:00 PM
@srutzky nah. i can't downvote you
 

« first day (2026 days earlier)