DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:from:to:cc:references:in-reply-to:subject:date:message-id:mime-version:content-type:content-transfer-encoding:x-mailer:thread-index:content-language;
	b=BmR7jwQUd31M1b62uw6BwYZa1OC47y4W5q0XGMvOU2f8UwwZ6Tfgo8nxqPfv0DN6qBO8pZhNgX9lgiWsiUY4xTuQ7OzF+t6dzKSsMunqN50EsjFNFljFkjGlTp4C0ExWIdPanKexkAjNmvdCF3Kojn6y/SjmJ4nYgxriCfzkuCk=
From: "Jyoti Seth" <jyotiseth2001@gmail.com>
To: "'Dmitry Turin'" <sql4-en@narod.ru>
Cc: <pgsql-sql@postgresql.org>
References: <00b101c7c51d$7754fb50$65fef1f0$@com>
	<414476065.20070716161857@narod.ru>
In-Reply-To: <414476065.20070716161857@narod.ru>
Subject: Re: [OBORONA-SPAM]  calling webservice through postgresql function
Date: Tue, 17 Jul 2007 10:48:41 +0530
Message-ID: <002e01c7c831$f2b61380$d8223a80$@com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
Thread-Index: AcfHrothrQb+WgNdRzubxQc1sXV9mgAgrkeQ
Content-Language: en-us

Hello Dmity,

As suggested by Richard Huxton in this forum we can use any of the
"untrusted" procedural languages to access resources outside the database
(e.g. pl/perlu).

You can get the code to call the webservice from the postgresql function
from this url. http://www.pgsql.cz/index.php/PL/Perlu_-_Untrusted_Perl_(en)

Thanks,
Jyoti

-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]
On Behalf Of Dmitry Turin
Sent: Monday, July 16, 2007 6:49 PM
To: pgsql-sql@postgresql.org
Subject: Re: [OBORONA-SPAM] [SQL] calling webservice through postgresql
function

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


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster