Received: from localhost (maia-5.hub.org [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id 6D84B9FB6F9
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 16 Jul 2007 10:34:45 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024)
	with ESMTP id 64501-06 for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 16 Jul 2007 10:34:26 -0300 (ADT)
X-Greylist: delayed 00:16:51.194317 by SQLgrey-1.7.5
Received: from smtp3.yandex.ru (smtp3.yandex.ru [213.180.200.14])
	by postgresql.org (Postfix) with ESMTP id C67539FB1CD
	for <pgsql-sql@postgresql.org>; Mon, 16 Jul 2007 10:34:40 -0300 (ADT)
Received: from dial-up.82.209.218.22.grodno.by ([82.209.218.22]:19953 "EHLO
	asu2.mshome.net" smtp-auth: "sql4-en" TLS-CIPHER: <none> TLS-PEER-CN1:
	<none>) by mail.yandex.ru with ESMTP id S4747674AbXGPNRd (ORCPT
	<rfc822;pgsql-sql@postgresql.org>); Mon, 16 Jul 2007 17:17:33 +0400
X-Comment: RFC 2476 MSA function at smtp3.yandex.ru logged sender identity as:
	sql4-en
Date: Mon, 16 Jul 2007 16:18:57 +0300
From: Dmitry Turin <sql4-en@narod.ru>
X-Mailer: The Bat! (v3.85.03) Professional
Reply-To: Dmitry Turin <sql4-en@narod.ru>
X-Priority: 3 (Normal)
Message-ID: <414476065.20070716161857@narod.ru>
To: pgsql-sql@postgresql.org
Subject: Re: [OBORONA-SPAM]  calling webservice through postgresql function
In-Reply-To: <00b101c7c51d$7754fb50$65fef1f0$@com>
References: <00b101c7c51d$7754fb50$65fef1f0$@com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.624 tagged_above=0 required=5 tests=AWL=0.623,
	BAYES_50=0.001
X-Spam-Level: 
X-Archive-Number: 200707/94
X-Sequence-Number: 28829

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