| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Ricardo Javier Aranibar León <ricardo_jal(at)hotmail(dot)com>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: |
| Date: | 2002-09-20 10:35:59 |
| Message-ID: | 200209201135.59993.dev@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Lehuta | 2002-09-20 12:30:08 | timestamp parse error |
| Previous Message | Richard Huxton | 2002-09-20 09:23:43 | Re: check source of trigger |