| From: | Andreas Schmitz <a(dot)schmitz(at)cityweb(dot)de> |
|---|---|
| To: | Ricardo Javier Aranibar León <ricardo_jal(at)hotmail(dot)com>, pgsql-sql(at)postgresql(dot)org |
| Cc: | ricardo_jal(at)linuxmail(dot)org |
| Subject: | Re: query concat |
| Date: | 2002-09-20 15:06:04 |
| Message-ID: | 200209201706.04862.a.schmitz@cityweb.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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(dot)schmitz(at)cityweb(dot)de
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2002-09-20 15:09:22 | Re: query concat |
| Previous Message | Ricardo Javier Aranibar León | 2002-09-20 14:46:26 | query concat |