From: | Dmitry Turin <sql4-en(at)narod(dot)ru> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: [OBORONA-SPAM] calling webservice through postgresql function |
Date: | 2007-07-16 13:18:57 |
Message-ID: | 414476065.20070716161857@narod.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Good day, Jyoti.
JS> I want to call webservice from my postgresql database. Please let me know if anyone has idea.
Idia or proper tool?
If idea, I offer to append some code into source of pg.
I already raised this question in topic
"We all are looped on Internet",
in which i read, that the most widespread transport protocol is HTTP,
and the most general format for data is XML (XHTML).
Idea is so: if we made
create table a (
id num primary key,
data float
);
create table b (
id num primary key,
ref num references a(id),
data float
);
create table c (
id num primary key,
link num references b(id),
data float
);
insert into a values (1, 12.3);
insert into b values (10, 1, 23.4);
insert into b values (20, 1, 34.5);
insert into b values (30, 1, 45.6);
insert into c values (100,10,56.7);
insert into c values (101,10,67.8);
insert into c values (200,20,78.9);
insert into c values (201,20,89.1);
insert into c values (300,30,91.2);
we need simple request 'a.b.c' to get
<a id=1 data=12.3>
<b id=10 data=23.4>
<c id=100 data=56.7/>
<c id=101 data=67.8/>
</b>
<b id=20 data=34.5>
<c id=200 data=78.9/>
<c id=201 data=89.1/>
</b>
<b id=30 data=45.6>
<c id=200 data=91.2/>
</b>
</a>
Request 'a.b.c' allow to avoid php,etc,
that is very necessary for unskilled users!
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
Unicode2 (2.0.0) http://unicode2.chat.ru
Computer2 (2.0.3) http://computer20.chat.ru
From | Date | Subject | |
---|---|---|---|
Next Message | Hélder M. Vieira | 2007-07-16 22:00:47 | Re: Having the sum of two queries |
Previous Message | Roberto Spier | 2007-07-16 11:57:08 | Re: Having the sum of two queries |