From: Andreas Schmitz <a.schmitz@cityweb.de>
To: Ricardo Javier Aranibar León <ricardo_jal@hotmail.com>
To: pgsql-sql@postgresql.org
Cc: ricardo_jal@linuxmail.org
Subject: Re: query concat
Date: Fri, 20 Sep 2002 17:06:04 +0200
Message-ID: <200209201706.04862.a.schmitz@cityweb.de> (raw)
In-Reply-To: <F9ao8KK8ZtP0kvdIBir000092c1@hotmail.com>
References: <F9ao8KK8ZtP0kvdIBir000092c1@hotmail.com>
On Friday 20 September 2002 16:46, Ricardo Javier Aranibar León wrote:
> Hi List,
Hello
>
> The Table "result"(I like this information)
> numtti | numorden | tt | usuario | estado |
> ----------+---------------------------+--------+---------+---------+
> TTI02000006| ORD02000044, ORD02000045..| 100029 | joroza | CERRADO |
> TTI02000007| ORD02000061, ORD02000064 | 100051 | pdorado | REVISION|
> TTI02000008| ORD02000042, ORD02000043 | 56729 | joroza | CERRADO |
>
Normally I would say use a "create view as select ... .". but I am not sure if
this will display your needs. Do you really need the data like "ORD02000044,
ORD02000045..." ? Then you should use an array or set datatype. They are
normally not nice to handel.
regards
-andreas
--
Andreas Schmitz - Phone +49 201 8501 318
Cityweb-Technik-Service-Gesellschaft mbH
Friedrichstr. 12 - Fax +49 201 8501 104
45128 Essen - email a.schmitz@cityweb.de
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: a.schmitz@cityweb.de, ricardo_jal@hotmail.com, ricardo_jal@linuxmail.org
Subject: Re: query concat
In-Reply-To: <200209201706.04862.a.schmitz@cityweb.de>
* 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