Re: We all are looped on Internet: request + transport = invariant

From: Dmitry Turin <sql4-en(at)narod(dot)ru>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: We all are looped on Internet: request + transport = invariant
Date: 2007-04-20 14:49:08
Message-ID: 4635310500.20070420174908@narod.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

>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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andrew Sullivan 2007-04-20 15:52:03 Re: We all are looped on Internet: request + transport = invariant
Previous Message Richard Huxton 2007-04-20 14:32:28 Re: Function to return a multiple colmn table or view