0
\$\begingroup\$
 Table "matrices"
 Column |  Type  | Modifiers
--------+--------+-----------
 matrix | text[] | not null

rows count 2,values are in this format given below

     matrix
-------------------
 {{1,2,3},{4,5,6}}
 {{a,b,c},{d,e,f}}

output i'm looking for in this format

     matrix
---------------------
 {{1,4},{2,5},{3,6}}
 {{a,d},{b,e},{c,f}}

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.

\$\endgroup\$
1
  • \$\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.