I should have added that the "concatenation" of the data to 10 20
or 10 30 or something is not really important how it is done, the
main point is to get only two fields in each row that is returned.
If the result is concatenated would be easiest, but perhaps there are
other ways to combine all the x values?
2010/6/17 A B <gentosaker(at)gmail(dot)com>:
> The table is table foo( id integer, x integer); and let the data be
> id x
> 1 10
> 1 20
> 2 20
> 3 30
> 3 10
> Now I would like to get the data in a format like this
> 1 , 10 20
> 2 , 20
> 3 , 10 30
> where id is the first field, and the second field is the x values sorted.
> Is there a simple way to do this?
In response to
pgsql-novice by date
|Next:||From: Andreas Kretschmer||Date: 2010-06-17 15:25:55|
|Subject: Re: How to combine many rows into one row (byconcatenation?) ?|
|Previous:||From: Atif Jung||Date: 2010-06-17 15:19:20|
|Subject: Re: Runnning operating system commands from an SPL|