Re: Library - Mailing list pgsql-novice

From Thomas Kellerer
Subject Re: Library
Date
Msg-id i7sgmi$f05$1@dough.gmane.org
Whole thread Raw
In response to Library  ("Charles Holleran " <scorpdaddy@hotmail.com>)
List pgsql-novice
Charles Holleran, 28.09.2010 12:21:
> A nice string concatenation aggregator in pg would be nice. Is there
> one in 8.4? I've been using array_agg but it's not quite the same.

In 8.4 you can simply combine array_to_string() and and array_agg():

In 9.0 you can use string_agg()

Thomas



pgsql-novice by date:

Previous
From: Thom Brown
Date:
Subject: Re: Library
Next
From: "Rob Richardson"
Date:
Subject: Timestamp confusion