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