I 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...
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.
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 😺.
@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.
I 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?
