Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 0CCDC476E57 for ; Fri, 20 Sep 2002 11:18:34 -0400 (EDT) Received: from linux012.intern.cityweb.de (linux012.intern.cityweb.de [195.71.215.252]) by postgresql.org (Postfix) with ESMTP id E9CEA476E46 for ; Fri, 20 Sep 2002 11:18:32 -0400 (EDT) Received: from zahedi.intern.cityweb.de (zahedi.intern.cityweb.de [193.189.226.198]) by linux012.intern.cityweb.de (8.11.0/8.11.0) with ESMTP id g8KFGUs15633; Fri, 20 Sep 2002 17:16:30 +0200 Content-Type: text/plain; charset="iso-8859-1" From: Andreas Schmitz Reply-To: a.schmitz@cityweb.de Organization: Cityweb Network To: Ricardo Javier Aranibar =?iso-8859-1?q?Le=F3n?= , pgsql-sql@postgresql.org Subject: Re: query concat Date: Fri, 20 Sep 2002 17:06:04 +0200 User-Agent: KMail/1.4.1 Cc: ricardo_jal@linuxmail.org References: In-Reply-To: MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <200209201706.04862.a.schmitz@cityweb.de> X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/245 X-Sequence-Number: 9522 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