From: Richard Broersma Jr <rabroersma@yahoo.com>
To: Frank Bax <fbax@sympatico.ca>
To: pgsql-sql@postgresql.org
Subject: Re: How to get a result in one row
Date: Wed, 21 Jun 2006 11:24:41 -0700 (PDT)
Message-ID: <20060621182441.85807.qmail@web31803.mail.mud.yahoo.com> (raw)
In-Reply-To: <5.2.1.1.0.20060621140420.04580180@pop6.sympatico.ca>
> >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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: rabroersma@yahoo.com, fbax@sympatico.ca
Subject: Re: How to get a result in one row
In-Reply-To: <20060621182441.85807.qmail@web31803.mail.mud.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox