From: Richard Huxton <dev@archonet.com>
To: Dmitry Turin <sql4-en@narod.ru>
Cc: pgsql-sql@postgresql.org
Subject: Re: Fwd: Re[2]: We all are looped on Internet: request + transport = invariant
Date: Tue, 24 Apr 2007 13:40:52 +0100
Message-ID: <462DFAD4.7030001@archonet.com> (raw)
In-Reply-To: <3817356375.20070424150200@narod.ru>
References: <14110647859.20070413105812@narod.ru>
<20070413150936.GA31517@phlogiston.dyndns.org>
<1684192906.20070419090827@narod.ru>
<20070419134808.GB14187@phlogiston.dyndns.org>
<814860828.20070420120819@narod.ru>
<4628A08F.9050804@archonet.com>
<1177072978.760.40.camel@pampa>
<7939450187.20070420185808@narod.ru>
<1177095450.760.71.camel@pampa>
<1312216062.20070423112045@narod.ru>
<1177329421.737.39.camel@pampa>
<3817356375.20070424150200@narod.ru>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, sql4-en@narod.ru
Subject: Re: Fwd: Re[2]: We all are looped on Internet: request + transport = invariant
In-Reply-To: <462DFAD4.7030001@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox