Re: query concat

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