Subject FIREBIRD PIVOT function or Matrix
Author Stef

Hi all,


I don’t see a PIVOT function available in Firebird 2.5


What would be the best way to design and query a matrix in firebird.


I need a distance matrix to indicate the distance between several cities.  Cities will be need to be added and distances adjusted as time goes by.


Any suggestions on my DB design and query to display the values in matrix (pivot) format?


Stef van der Merwe