Table "matrices"
 Column |  Type  | Modifiers
 matrix | text[] | not null

rows count 2,values are in this format given below


output i'm looking for in this format


can anybody suggest me a better solution, i tried crosstab with giving 2 integer value,it didn't work in my server,these syntaxes are new to me.

  • \$\begingroup\$ Welcome to Code Review! Unfortunately your post is off-topic because (1) there is no code for us to review, and (2) the title of your question is of the form "how do I do X?" which is likely a better fit for Stack Overflow. Please read How do I ask a good question? \$\endgroup\$ – Setris Mar 14 at 7:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.