From: Richard Huxton <dev@archonet.com>
To: Ricardo Javier Aranibar León <ricardo_jal@hotmail.com>
To: pgsql-sql@postgresql.org
Subject: Re:
Date: Fri, 20 Sep 2002 11:35:59 +0100
Message-ID: <200209201135.59993.dev@archonet.com> (raw)
In-Reply-To: <F39LVbNDN4CxpAOAkK50000781b@hotmail.com>
References: <F39LVbNDN4CxpAOAkK50000781b@hotmail.com>
On Thursday 19 Sep 2002 9:30 pm, Ricardo Javier Aranibar León wrote:
> Hi list,
Hi Ricardo
> I need your colaboration,I like a table or view with this information
> from 2 tables "ticket" and "orden_respuesta".
>
> numtti | numorden | tt | usuario | estado |
> -----------+---------------------------+--------+---------+---------+
> TTI02000006| ORD02000046, ORD02000045..| 100029 | joroza | CERRADO |
>
> -------------+--------+---------+----------+
> TTI02000006 | 100029 | joroza | CERRADO |
>
> -------------+-------------
> ORD02000046 | TTI02000006
> ORD02000045 | TTI02000006
Do a search on aggregate functions and "concat" in the mailing list archives,
also see the Postgresql Cookbook on techdocs.postgresql.org, I think there
might be something there for you.
That's assuming you don't care about order of course.
- Richard Huxton
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: dev@archonet.com, ricardo_jal@hotmail.com
Subject: Re:
In-Reply-To: <200209201135.59993.dev@archonet.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