From: Dmitry Turin <sql4-en@narod.ru>
To: pgsql-sql@postgresql.org
Subject: Re: We all are looped on Internet: request + transport = invariant
Date: Fri, 20 Apr 2007 17:49:08 +0300
Message-ID: <4635310500.20070420174908@narod.ru> (raw)
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>
>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.
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: sql4-en@narod.ru
Subject: Re: We all are looped on Internet: request + transport = invariant
In-Reply-To: <4635310500.20070420174908@narod.ru>
* 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