Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id 585099FB5B2
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 20 Apr 2007 11:46:43 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024)
	with ESMTP id 22754-05 for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 20 Apr 2007 11:46:32 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from smtp2.yandex.ru (smtp2.yandex.ru [213.180.200.18])
	by postgresql.org (Postfix) with ESMTP id DF2429FB599
	for <pgsql-sql@postgresql.org>; Fri, 20 Apr 2007 11:46:29 -0300 (ADT)
Received: from [82.209.238.118] ([82.209.238.118]:12815 "EHLO asup_tur"
	smtp-auth: "sql4-en" TLS-CIPHER: <none> TLS-PEER-CN1: <none>)
	by mail.yandex.ru with ESMTP id S3375475AbXDTOqS (ORCPT
	<rfc822;pgsql-sql@postgresql.org>); Fri, 20 Apr 2007 18:46:18 +0400
X-Comment: RFC 2476 MSA function at smtp2.yandex.ru logged sender identity as:
	sql4-en
Date: Fri, 20 Apr 2007 17:49:08 +0300
From: Dmitry Turin <sql4-en@narod.ru>
X-Mailer: The Bat! (v2.01) Personal
Reply-To: Dmitry Turin <sql4-en@narod.ru>
X-Priority: 3 (Normal)
Message-ID: <4635310500.20070420174908@narod.ru>
To: pgsql-sql@postgresql.org
Subject: Re: We all are looped on Internet: request + transport = invariant
In-Reply-To: <4628A08F.9050804@archonet.com>
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>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.523 tagged_above=0 required=5 tests=AWL=0.708,
	BAYES_40=-0.185
X-Spam-Level: 
X-Archive-Number: 200704/187
X-Sequence-Number: 28187

>How do I know with the "id=200" that 200 is an int rather than a byte or string?

Field (of database) and attribute (of tag) are put into one-to-one
correspondence.
Thus datatype of attribute is datatype of field (which is specified
during "create table" or "alter table").

>how do we add the new table?

by DDL, of course.
TML don't create/alter/drop table/index.

>accesses to a database want to retrieve a simple tree

It's difficult to bring inverse example - when it's necessary to get
records of only one table. Really, in life (not in math problems).

>your alternative access method doesn't let me grab "nets" (directed graphs, possibly cyclic)

Yes.
You must inquere records of two tables (nodes and bonds) separately.

>> After that, look at source of server programs, servicing this databases.
>> These programs get part of net (not part of one table!, not part of
>> joined tables! not part of one view!) and put it into program-visualizer.
>Also not trees (necessarily)

No. Server program inqueries tree (as part of graph).

>why you just don't write this as a simple php/perl/ruby/whatever script?

Not me.
Not programmer.
I speak about appied specialists (physicists, biologists, etc), which
can NOT do that.
Join of SQL and php (using libraries) is problem for them.

>it's just an afternoon's work

Not for mentioned people.