each record separately,
including to each record of system table
http://sql40.chat.ru/site/sql40/en/author/ddl_eng.htm#department )
connect
ra="data.storage.com" username="Johnson" password="pwdj" nickname="db4";
update sys-nicknames set passwo
er languages.
JT> So I'd just use libpq.dll.
Similarly, What Delphi's object should be used to connect via libpq.dll
(instead of BDE-components TTable, TDatabase -
i'd like to know all ways to connect Postgres and Delphi)?
Dmitry Turin
SQL4 (4.3.0) http://sql40.chat.ru
HTML6
separately,
including to each record of system table
http://sql40.chat.ru/site/sql40/en/author/ddl_eng.htm#department )
connect
ra="data.storage.com" username="Johnson" password="pwdj" nickname="db4";
update pg_nicknames set password=pwdj where
ra=&q
need simple instruments, instead of your (in you link)
JS>>CREATE OR REPLACE FUNCTION
JS>>use DBI;
JS>>my $dbh = DBI->connect('dbi:mysql:'.$_[0],$_[1],$_[2],
JS>> { RaiseError => 1, AutoCommit = > });
Do yo
e wrong once again:
advantage is to __refuse__ from procedural language (to install connect)
instead of put it from outside of DBMS into inside of DBMS.
All, which is necessary, is DBMS itself listen some port/protocol.
Dmitry Turin
SQL4 (4.1.3) http://sql40.chat.ru
HTML6 (6.3.0) ht
rs!
Details are on:
http://sql40.chat.ru/site/sql40/en/author/introduction_eng.htm
http://sql40.chat.ru/site/sql40/en/author/determination_eng.htm
http://sql40.chat.ru/site/sql40/en/author/inout_eng.htm
Dmitry Turin
HTML6 (6.1.2) http://html60.chat.ru
SQL4 (4.1.2) http://sql40.chat.ru
U
Good day.
My name is Dmitry Turin,
i want to discuss in newsgroup 'comp.database.theory'.
Please, prompt address of any NNTP-server ?
Dmitry Turin
SQL4 (4.1.0) http://sql40.chat.ru
HTML6 (6.1.0) http://html60.chat.ru
Computer2 (2.0.2) http://computer
or visualization, as "pgsql.exe"
J> Excel with ODBC
Using this is over skills of users.
J> However, someone will still have to learn SQL
SQL is point, which may not be avoided (now).
Thus SQL is separate topic.
J> The average man or woman on the street
For what you say about street ?
Average people, which you can meet on street, make physical job.
Dmitry Turin
http://html6.by.ru
http://sql4.by.ru
http://computer2.by.ru
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Good day, Andrew.
AS> translates it into proper SQL?
How are you going to send and get XML-data by SQL ?
Dmitry Turin
http://html6.by.ru
http://sql4.by.ru
http://computer2.by.ru
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
t city.name as start, city.name as end, flight.t1, flight.t2, day
>> from city, flight;
>> x >>;
RH> Hang on - you're using SQL. Why not just use pgadmin and paste the
RH> results from my query if I'm using SQL anyway?
paste by hands?
RH> Sorry - you didn'
e assistance of a
J> technical specialist or a full-time programming team, but what's wrong
J> with that?
expenses of money, time, nerve to explain task to other man
P.S.
Joe, send letter only to mailing list, not to me.
Dmitry Turin
http://html6.by.ru
http://sql4.by.ru
ht
date and see a list of flights
RH> (sorted by cost, or length or some such). At present I'll build that
RH> with e.g. PHP + SQL => PostgreSQL. What part of the process does TML
RH> make easier?
You use only SQL and small simple part (simple part !) of TML to
transport data.
P.S.
Soon i add sorting into TML.
P.P.S.
Richard, send letter only to mailing list, not to me.
Dmitry Turin
http://html6.by.ru
http://sql4.by.ru
http://computer2.by.ru
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
date and see a list of flights
RH> (sorted by cost, or length or some such). At present I'll build that
RH> with e.g. PHP + SQL => PostgreSQL. What part of the process does TML
RH> make easier?
You use only SQL and small simple part (simple part !) of TML to
transport data.
P.S.
Soon i add sorting into TML.
Dmitry Turin
http://html6.by.ru
http://sql4.by.ru
http://computer2.by.ru
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
es a change to SQL DDL.
You are worried about technical realization or ideological orthodoxy ?
Or maybe about anything else ?
J> if someone comes along and wants to do
J> SELECT name, SUM(salary) FROM employee GROUP BY name?
create view x as SELECT name, SUM(salary) FROM employee GROUP BY n
, that it is no database in general.
BD> I agree with them.
BD> Are you agree to make comparison in discussion with me?
And what's about comparison ?
Dmitry Turin
http://html6.by.ru
http://sql4.by.ru
http://computer2.by.ru
---(end of broadcast)-
BY department?
It is always "group by", because it is field of record "department"
P.S.
If you don't like to put sign "#" before field "sum",
or you don't like absence of sorting NOW
(it's possible, that i add sorting),
the
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.
Dmitry Turin
http://html6.by.ru
http://sql4.by.ru
http://computer2.
akit-2.01.tar.gz, 607 Kb).
Our users consider, that it is no database in general.
I agree with them.
Are you agree to make comparison in discussion with me?
Dmitry Turin
http://html6.by.ru
http://sql4.by.ru
http://computer2.by.ru
---(end of broadcast)---
TIP 6: explain analyze is your friend
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
s place,
when i can find programmer, which can (and maybe would like) add parser to
database.
We all together can make that, i hope to that.
Dmitry Turin
http://html6.by.ru
http://sql4.by.ru
---(end of broadcast)---
TIP 1: if posting/reading t
. have to learn
They must nothing, they are forced
>That doesn't mean they can get away without learning a bit about ... Perl
Why?
Dmitry Turin
http://html60.by.ru
http://sql40.by.ru
---(end of broadcast)---
TIP 4: Have you searched
how to use TML as library :)
>there are libraries that provide plenty of XML formatting
Once more: XML is side effect! If you know better format for tree,
please describe it.
Gold is ejection of shim (gasket): php, perl, etc.
Dmitry Turin
http://html6.by.ru
http://sql4.by.ru
---
;.
> you'll be better off discussing this in comp.databases.theory
There are two reason to discuss TML in this forum:
1. postgres is my favorite database,
2. discussion not in theory forum, but in forum of real database
approach to realization in greater degree.
>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 ne
insert into c values (101,10,20,89.1);
insert into c values (200,30,40,91.2);
insert into c values (201,30,40,88.8)
But TML is:
a.b/ref1.c/lnk1
---
P.S.
I'm very glad to get acquainted with you, and i'm much interesting to talk with
you.
Let's to write maximum simply, let's to use
Usage of database consist of
request and transportation of results into visualizer.
We all are looped on Internet, thus visualizer should be remoted.
The most general format for data is XML.
We also need to choose transport protocol:
the most widespread is HTTP.
SQL could send data so.
Now SQL do
>What does this do that inheritance doesn't already do? I don't think I see
>anything.
- So, we have proved, that all, what you offer to make on your a-a-a...
Fortran, is possible to make on assembler.
- First, I know this without you, second, speech was not about that.
Newness is not "what",
27 matches
Mail list logo
