On Wed, Nov 12, 2008 at 3:59 AM, zxo102 ouyang <zxo102@xxxxxxxxx> wrote: > Hi everyone, > My data with same timestamp "2008-11-12 12:12:12" in postgresql are as > follows > > rowid data unit channel create_on > ------------------------------------------------------------------------------ > 1 1.5 MPa channel1 2008-11-12 12:12:12 > 2 2.5 M3 channel2 2008-11-12 12:12:12 > 3 3.5 M3 channel3 2008-11-12 12:12:12 > 4 4.5 t channel4 2008-11-12 12:12:12 > ------------------------------------------------------------------------------ > > I would like to "group" them into one line with SQL like > > 1.5 MPa 2.5 M3 3.5 M3 4.5 t 2008-11-12 12:12:12 > Lookup the crosstab contrib functions. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
