interval output format ? - Mailing list pgsql-general

Hello,

Given the following table:

pilotage=# \d vols
           Table "vols"
  Attribute  |   Type   | Modifier
-------------+----------+----------
 jour        | date     |
 modele      | char(20) |
 matricule   | char(20) |
 pilote1     | char(20) |
 pilote2     | char(20) |
 origine     | char(20) |
 destination | char(20) |
 double      | interval |
 comandant   | interval |
 description | text     |
 code        | char(10) |


and the following query:

    pilotage=# select sum(comandant) from vols;
               sum
    --------------------------
     @ 1 day 19 hours 18 mins
    (1 row)

how can I ask postgres  to return

    43:18

instead of

    @ 1 day 19 hours 18 mins

Thanks,
David