Re: [GENERAL] pg SQL question

2005-01-22 Thread David Fetter
On Sat, Jan 22, 2005 at 02:03:58PM -0700, Ed L. wrote: > > There's probably an obvious answer for this, but I couldn't see it > in the docs. What's the simplest way to concatenate multiple > same-column values in SQL? > > For example, suppose I have table foo (key integer, id integer, > entry va

Re: [GENERAL] pg SQL question

2005-01-22 Thread Richard Poole
On Sat, Jan 22, 2005 at 02:03:58PM -0700, Ed L. wrote: > > There's probably an obvious answer for this, but I couldn't see it in the > docs. What's the simplest way to concatenate multiple same-column values > in SQL? You can create an aggregate that does nothing but concatenate the entries:

[GENERAL] pg SQL question

2005-01-22 Thread Ed L.
There's probably an obvious answer for this, but I couldn't see it in the docs. What's the simplest way to concatenate multiple same-column values in SQL? For example, suppose I have table foo (key integer, id integer, entry varchar) with data key id entry 1 1