Skip site navigation (1) Skip section navigation (2)

Re: Concatenate results of a single column query

From: Christoph Haller <ch(at)rodos(dot)fzk(dot)de>
To: gsstark(at)mit(dot)edu (Greg Stark)
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Concatenate results of a single column query
Date: 2004-04-19 15:15:14
Message-ID: 200404191315.PAA09557@rodos (view raw or flat)
Thread:
Lists: pgsql-sql
> 
> 
> Marco Lazzeri <marcomail(at)noze(dot)it> writes:
> 
> > SELECT
> >   p.name, ARRAY(SELECT nicknames FROM people WHERE people.id = p.id)
> > FROM people AS p
> 
> > Any suggestions?
> 
> Something like:
> 
> db=> create aggregate array_aggregate (basetype = integer, sfunc = array_append, stype = integer[], initcond = '{}');
> CREATE AGGREGATE
> 
> db=> select array_aggregate(id) from tab;
>                                                                       array_aggregate                                                                       
> ------------------------------------------------------------------------------------------------------------------------------------------------------------
>  {1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,28,29,30,31,32,33,34,36,37,38,39,40,41,42,43,27,26,44,45,46,47,48,49,50,51,52,53,54,35}
> (1 row)
> 
> -- 
> greg
> 
> 
Interesting feature, but I cannot find function array_append: 
ERROR:  AggregateCreate: function array_append(integer[], integer) does not exist

TIA 

Regards, Christoph 


In response to

Responses

pgsql-sql by date

Next:From: scott.marloweDate: 2004-04-19 15:33:35
Subject: Re: Update is very slow on a bigger table
Previous:From: Gary StainburnDate: 2004-04-19 15:01:53
Subject: Re: three-way join

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group