how to build this list ?

From: juerg(dot)rietmann(at)pup(dot)ch
To: pgsql-sql(at)postgresql(dot)org
Subject: how to build this list ?
Date: 2002-05-16 12:38:02
Message-ID: OF3F2ABA05.D9201794-ONC1256BBB.00436E1A-C1256BBB.00457696@pup.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello there

How to build this list ? I have no idea how to start, thanks for any help
!!

Table order :
orderid main
------------------------------------------------
11111111 true
11111112 false
11111113 false
22222221 true
11111114 false
11111115 false
22222222 false
22222223 false

Table cylinder :
cylinderid type orderid
-------------------------------------------------
8888 01 11111111
8866 03 22222221
7986 01 11111111
8796 03 22222222
9876 03 22222222
8732 01 11111111
9876 03 11111112
7654 02 11111113
4532 04 11111115
4318 03 11111112
6653 02 11111113

The list I need :

11111111 (main order)
8888 01 (cylinderid, type)
7986 01 (cylinderid, type)
8732 01 (cylinderid, type)
11111112 (suborder)
9876 03 (cylinderid, type)
4318 03 (cylinderid, type)
11111113 (suborder)
7654 02 (cylinderid, type)
6653 02 (cylinderid, type)
11111114 (suborder)
11111115 (suborder)
22222221 (main order)
8866 03 (cylinderid, type)
22222222 (suborder)
8796 03 (cylinderid,type)
9876 03 (cylinderid,typ)
22222223 (suborder)

__________________________________________________

PFISTER + PARTNER, SYSTEM - ENGINEERING AG
Juerg Rietmann
Grundstrasse 22a
6343 Rotkreuz
Switzerland

internet : www.pup.ch
phone : +4141 790 4040
fax : +4141 790 2545
mobile : +4179 211 0315
__________________________________________________

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2002-05-16 15:12:26 Re: Rules and Triggers
Previous Message Ludwig Lim 2002-05-16 04:59:40 Rules and Triggers