Re: Fwd: Re[2]: We all are looped on Internet: request + transport = invariant
От | Richard Huxton |
---|---|
Тема | Re: Fwd: Re[2]: We all are looped on Internet: request + transport = invariant |
Дата | |
Msg-id | 462DFAD4.7030001@archonet.com обсуждение исходный текст |
Ответ на | Fwd: Re[2]: We all are looped on Internet: request + transport = invariant (Dmitry Turin <sql4-en@narod.ru>) |
Список | pgsql-sql |
Dmitry Turin wrote: > Good day, Joe. > >>>> I would change your examples to use less abstract >>>> data, like department/employee, customer/product/order/order_line > > J> I contend that then you'd find more people > J> receptive to your ideas or at least able to criticize them from more > J> concrete viewpoints. > > I expected, that you already read > http://sql4.by.ru/site/sql40/en/author/wave_eng.htm > (i added output into this paper). > Case of "department/employee" is "Example 1" on this paper. I'd not expect people to read lengthy articles on a general-questions mailing list, but I've skimmed at least as far as example 2. 1. What does it mean for one flight to be contained within another? I can see how one flight might follow another, but not contained. Do you not need some new object "flight_chain" or similar? 2. Surely a flight should contain two cities (since it connects two cities). Alternatively, the <city> needs to indicate to which it's referring either as <startcity>/<endcity> or <city fromto="start"> or similar. 3. How am I constructing these queries? The whole point was so I didn't have to learn SQL, yes? Unfortunately, the syntax for these queries isn't obvious enough to me that I can see how to write them without some form of query-builder, or reference manual. 4. How am I using these queries? I'm still not clear what use it is to have XML without a schema. Let's say I want to build a holiday website. How does this TML setup avoid me having to write any php/perl/etc? -- Richard Huxton Archonet Ltd
В списке pgsql-sql по дате отправления: