Re: How to get a result in one row

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: Frank Bax <fbax(at)sympatico(dot)ca>, pgsql-sql(at)postgresql(dot)org
Subject: Re: How to get a result in one row
Date: 2006-06-21 18:24:41
Message-ID: 20060621182441.85807.qmail@web31803.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> >I'd like to get the result in only one row:
> > id | nick
> >------+------
> >22192 | A,T
> This question is in the archives (probably more than once). The answer is...>
> Read the online docs about aggregate functions. There is an example that
> does (almost) exactly what you are asking.

Where you referring to the tread regarding the LTREE contrib module for postgresql?
http://archives.postgresql.org/pgsql-general/2006-06/msg00745.php

I know I've seen this done using cursors in PL-PGSQL, but I would be interested if there was a
solution with pre-existing aggregates.

Regards,

Richard Broersma Jr.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Frank Bax 2006-06-21 19:15:20 Re: How to get a result in one row
Previous Message Frank Bax 2006-06-21 18:06:55 Re: How to get a result in one row