pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (16+ messages)  latest in thread

Message-ID: <462DFAD4.7030001@archonet.com>
Permalink:  ../462DFAD4.7030001@archonet.com/
Also on:    postgresql.org/message-id/462DFAD4.7030001@archonet.com

 · 

reply

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