From jyotiseth2001@gmail.com Fri Jul  13 07:17:16 2007
Received: from localhost (maia-4.hub.org [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 159269FB4BD
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 13 Jul 2007 04:17:16 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 75957-02 for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 13 Jul 2007 04:17:08 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from py-out-1112.google.com (py-out-1112.google.com
 [64.233.166.181])
	by postgresql.org (Postfix) with ESMTP id 0F5DE9FB310
	for <pgsql-sql@postgresql.org>; Fri, 13 Jul 2007 04:17:12 -0300 (ADT)
Received: by py-out-1112.google.com with SMTP id d32so707596pye
	for <pgsql-sql@postgresql.org>; Fri, 13 Jul 2007 00:17:07 -0700 (PDT)
DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta;
	h=domainkey-signature:received:received:from:to:subject:date:message-id:mime-version:content-type:x-mailer:thread-index:content-language;
	b=G/ZoQYzzsRbKgZS/IQNzUlFMMhqI+pAoHVvo1wInql1LPpVodbJMBKkMsO/0ZbBG6+MJ/z7bR4n1CnNrq61PtEbx/LVyk7NcmuPaL12bekr7J7iIpLjVod+gdrCzUNS6HP3DrFdGNCskYMFNipSVeLsDhKQUVyWCXl2NE/Zol+4=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:from:to:subject:date:message-id:mime-version:content-type:x-mailer:thread-index:content-language;
	b=UmZHiZnbhI6TVXXivcxONV0+XG/VxOjUXpXHC91smj7XWXj+2HnXUFAnBc40IQxps2T1eoFck+1U+CSc5S/NOhda5WLFPiLObr1fdyHIihNsDMVB9CybhxavimIdu9qawN3fKm0TaqIbzGP1e7L1HvGOep4pq4Lcs+gM76NStQk=
Received: by 10.141.26.17 with SMTP id d17mr395324rvj.1184311027234;
	Fri, 13 Jul 2007 00:17:07 -0700 (PDT)
Received: from bitdldt04 ( [122.162.171.165])
	by mx.google.com with ESMTP id f42sm19049858rvb.2007.07.13.00.17.04
	(version=SSLv3 cipher=RC4-MD5); Fri, 13 Jul 2007 00:17:06 -0700 (PDT)
From: "Jyoti Seth" <jyotiseth2001@gmail.com>
To: <pgsql-sql@postgresql.org>
Subject: calling webservice through postgresql function
Date: Fri, 13 Jul 2007 12:44:31 +0530
Message-ID: <00b101c7c51d$7754fb50$65fef1f0$@com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_00B2_01C7C54B.910D3750"
X-Mailer: Microsoft Office Outlook 12.0
Thread-Index: AcfFHXSXkNdaz+krScCCBXYoqwSdUQ==
Content-Language: en-us
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200707/78
X-Sequence-Number: 28813

This is a multipart message in MIME format.

------=_NextPart_000_00B2_01C7C54B.910D3750
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hi all,

 

I want to call webservice from my postgresql database. Please let me know if
anyone has idea.

 

Thanks,

Jyoti Seth


------=_NextPart_000_00B2_01C7C54B.910D3750
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">
<style>
<!--
 /* Font Definitions */
 @font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:purple;
	text-decoration:underline;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Calibri","sans-serif";
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;}
@page Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
	{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
 <o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
 <o:shapelayout v:ext=3D"edit">
  <o:idmap v:ext=3D"edit" data=3D"1" />
 </o:shapelayout></xml><![endif]-->
</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

<p class=3DMsoNormal>Hi all,<o:p></o:p></p>

<p class=3DMsoNormal><o:p>&nbsp;</o:p></p>

<p class=3DMsoNormal>I want to call webservice from my postgresql =
database.
Please let me know if anyone has idea.<o:p></o:p></p>

<p class=3DMsoNormal><o:p>&nbsp;</o:p></p>

<p class=3DMsoNormal>Thanks,<o:p></o:p></p>

<p class=3DMsoNormal>Jyoti Seth<o:p></o:p></p>

</div>

</body>

</html>

------=_NextPart_000_00B2_01C7C54B.910D3750--




From dev@archonet.com Fri Jul  13 07:28:47 2007
Received: from localhost (maia-4.hub.org [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 08CEF9FB90A
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 13 Jul 2007 04:28:47 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 76694-10 for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 13 Jul 2007 04:28:39 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from mail.metronet.co.uk (mail.metronet.co.uk [213.162.97.75])
	by postgresql.org (Postfix) with ESMTP id BB7499FB809
	for <pgsql-sql@postgresql.org>; Fri, 13 Jul 2007 04:28:43 -0300 (ADT)
Received: from server3.office.archonet.com
	(84-51-143-99.archon037.adsl.metronet.co.uk [84.51.143.99])
	by smtp.metronet.co.uk (MetroNet Mail) with ESMTP id 633AF1445D3;
	Fri, 13 Jul 2007 08:26:41 +0100 (BST)
Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36])
	by server3.office.archonet.com (Postfix) with ESMTP id 26F8827411A;
	Fri, 13 Jul 2007 08:26:41 +0100 (BST)
Message-ID: <46972930.30301@archonet.com>
Date: Fri, 13 Jul 2007 08:26:40 +0100
From: Richard Huxton <dev@archonet.com>
User-Agent: Thunderbird 2.0.0.0 (X11/20070326)
MIME-Version: 1.0
To: Jyoti Seth <jyotiseth2001@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: calling webservice through postgresql function
References: <00b101c7c51d$7754fb50$65fef1f0$@com>
In-Reply-To: <00b101c7c51d$7754fb50$65fef1f0$@com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200707/79
X-Sequence-Number: 28814

Jyoti Seth wrote:
> Hi all,
> 
> I want to call webservice from my postgresql database. Please let me know if
> anyone has idea.

You can use any of the "untrusted" procedural languages to access 
resources outside the database (e.g. pl/perlu), or of course C.

-- 
   Richard Huxton
   Archonet Ltd



From jyotiseth2001@gmail.com Fri Jul  13 07:34:16 2007
Received: from localhost (maia-3.hub.org [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 621CA9FBFC3
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 13 Jul 2007 04:34:16 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 48775-08 for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 13 Jul 2007 04:34:05 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from nz-out-0506.google.com (nz-out-0506.google.com
 [64.233.162.238])
	by postgresql.org (Postfix) with ESMTP id 32DCE9FBBA6
	for <pgsql-sql@postgresql.org>; Fri, 13 Jul 2007 04:34:13 -0300 (ADT)
Received: by nz-out-0506.google.com with SMTP id l8so336298nzf
	for <pgsql-sql@postgresql.org>; Fri, 13 Jul 2007 00:34:07 -0700 (PDT)
DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta;
	h=domainkey-signature:received: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=eN1hbvAG12dWPyfx3m12qo+BqfOtMdo6N6NkdhDBymVN6lH3WJ2uwcjUJrZcrN6Z0iRwjAPpJ/OGEuLTXVs9PgCxfQPQ8clZreIAfePhwCrsVF6dLc5EaP5Bypoh7XDozLHOv8HWrh6y6EZ3Fu+bI6sxVXwMoHsvruVrxC6vbBg=
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=XC8L+PLUSx7OpB1XMxGoOC5WIJUDFRlZBN0N7LjfulQ3Hdhw5tShRpajQQUX0p59OBZuP49qqPolNn1OUeOOyf1xnZrk/O4oAktUIg4Hwfq0lZNCmek2BGmKcjrvGDQKvZ8gh12+ygDACRqISOQHP6imM2sIcps35cK9P/UQhhk=
Received: by 10.141.68.10 with SMTP id v10mr396895rvk.1184312047306;
	Fri, 13 Jul 2007 00:34:07 -0700 (PDT)
Received: from bitdldt04 ( [122.162.171.165])
	by mx.google.com with ESMTP id c3sm12607926rvf.2007.07.13.00.34.04
	(version=SSLv3 cipher=RC4-MD5); Fri, 13 Jul 2007 00:34:06 -0700 (PDT)
From: "Jyoti Seth" <jyotiseth2001@gmail.com>
To: "'Richard Huxton'" <dev@archonet.com>
Cc: <pgsql-sql@postgresql.org>
References: <00b101c7c51d$7754fb50$65fef1f0$@com>
 <46972930.30301@archonet.com>
In-Reply-To: <46972930.30301@archonet.com>
Subject: Re: calling webservice through postgresql function
Date: Fri, 13 Jul 2007 13:01:30 +0530
Message-ID: <00b601c7c51f$d775d430$86617c90$@com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Mailer: Microsoft Office Outlook 12.0
Thread-Index: AcfFH25jPwm+T7DoQdezBVch7YzUvQAAC3PQ
Content-Language: en-us
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200707/80
X-Sequence-Number: 28815

Thanks a lot for ur quick response. I have searched a lot on net for code to
call a webservice through tcl/tk or any other scripting lang that is
supported by postgresql, but couldn't find one. If u can provide me some
code to call a web service through postgresql it would be a great help.

Thanks,
Jyoti Setj

-----Original Message-----
From: Richard Huxton [mailto:dev@archonet.com] 
Sent: Friday, July 13, 2007 12:57 PM
To: Jyoti Seth
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] calling webservice through postgresql function

Jyoti Seth wrote:
> Hi all,
> 
> I want to call webservice from my postgresql database. Please let me know
if
> anyone has idea.

You can use any of the "untrusted" procedural languages to access 
resources outside the database (e.g. pl/perlu), or of course C.

-- 
   Richard Huxton
   Archonet Ltd




From dev@archonet.com Fri Jul  13 07:37:54 2007
Received: from localhost (maia-4.hub.org [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id D7E6C9FBB2C
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 13 Jul 2007 04:37:54 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 79395-04 for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 13 Jul 2007 04:37:47 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from mail.metronet.co.uk (mail.metronet.co.uk [213.162.97.75])
	by postgresql.org (Postfix) with ESMTP id 240889FB955
	for <pgsql-sql@postgresql.org>; Fri, 13 Jul 2007 04:37:52 -0300 (ADT)
Received: from server3.office.archonet.com
	(84-51-143-99.archon037.adsl.metronet.co.uk [84.51.143.99])
	by smtp.metronet.co.uk (MetroNet Mail) with ESMTP id C8DFE14CE46;
	Fri, 13 Jul 2007 08:37:46 +0100 (BST)
Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36])
	by server3.office.archonet.com (Postfix) with ESMTP id AAEDE27411A;
	Fri, 13 Jul 2007 08:37:46 +0100 (BST)
Message-ID: <46972BCA.5050605@archonet.com>
Date: Fri, 13 Jul 2007 08:37:46 +0100
From: Richard Huxton <dev@archonet.com>
User-Agent: Thunderbird 2.0.0.0 (X11/20070326)
MIME-Version: 1.0
To: Jyoti Seth <jyotiseth2001@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: calling webservice through postgresql function
References: <00b101c7c51d$7754fb50$65fef1f0$@com>
 <46972930.30301@archonet.com>
	<00b601c7c51f$d775d430$86617c90$@com>
In-Reply-To: <00b601c7c51f$d775d430$86617c90$@com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200707/81
X-Sequence-Number: 28816

Jyoti Seth wrote:
> Thanks a lot for ur quick response. I have searched a lot on net for code to
> call a webservice through tcl/tk or any other scripting lang that is
> supported by postgresql, but couldn't find one. If u can provide me some
> code to call a web service through postgresql it would be a great help.

Just use pl/perlu (or pythonu or tclu) in whatever way you would 
normally "call a webservice". That side of things has nothing to do with 
PG (other than the fact that it will hold up your query).

If you don't know how to "call a webservice" then you'll need to check 
with one of the developer forums for your language of choice I'm afraid.

-- 
   Richard Huxton
   Archonet Ltd



From andreas.kretschmer@schollglas.com Fri Jul  13 07:46:37 2007
Received: from localhost (maia-4.hub.org [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 2FFD99FC094
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 13 Jul 2007 04:46:37 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 79710-07 for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 13 Jul 2007 04:46:30 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from moutng.kundenserver.de (moutng.kundenserver.de
	[212.227.126.171])
	by postgresql.org (Postfix) with ESMTP id 189979FBB46
	for <pgsql-sql@postgresql.org>; Fri, 13 Jul 2007 04:46:34 -0300 (ADT)
Received: from [194.25.154.138] (helo=webserv.wug.de)
	by mrelayeu.kundenserver.de (node=mrelayeu3) with ESMTP (Nemesis),
	id 0MKxQS-1I9FrA0lk5-0008D3; Fri, 13 Jul 2007 09:46:28 +0200
Received: from kretschmer by webserv.wug.de with local (Exim 3.36 #1)
	id 1I9Fr0-00014N-00
	for pgsql-sql@postgresql.org; Fri, 13 Jul 2007 09:46:18 +0200
Date: Fri, 13 Jul 2007 09:46:18 +0200
From: "A. Kretschmer" <andreas.kretschmer@schollglas.com>
To: pgsql-sql@postgresql.org
Subject: Re: calling webservice through postgresql function
Message-ID: <20070713074618.GA32089@a-kretschmer.de>
References: <00b101c7c51d$7754fb50$65fef1f0$@com>
 <46972930.30301@archonet.com>
	<00b601c7c51f$d775d430$86617c90$@com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <00b601c7c51f$d775d430$86617c90$@com>
X-OS: Debian/GNU Linux - weil ich es mir Wert bin!
X-Message-Flag: "Windows" is not the answer. "Windows" is the question and the
	answer is "no"!
User-Agent: Mutt/1.5.9i
X-Provags-ID: V01U2FsdGVkX18fVoZrIwToV9SjqqH3gB1bQH/42kqffdhRotw
	rjeKzHSEeiMB0irMeQocYOLdXXre4chne+Zr3R9ua72z1BF23a
	F7Yl889PzsB+nDcICjpQKXOyk0O9w6S
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200707/82
X-Sequence-Number: 28817

am  Fri, dem 13.07.2007, um 13:01:30 +0530 mailte Jyoti Seth folgendes:
> Thanks a lot for ur quick response. I have searched a lot on net for code to
> call a webservice through tcl/tk or any other scripting lang that is
> supported by postgresql, but couldn't find one. If u can provide me some
> code to call a web service through postgresql it would be a great help.

As Richard says, use an untrusted language like pl/perlU (U means
untrusted) to call arbitrary external programs.


Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net



From sql4-en@narod.ru Mon Jul  16 13:34:45 2007
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




From jyotiseth2001@gmail.com Tue Jul  17 05:21:33 2007
Received: from localhost (maia-2.hub.org [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id 1E9C49FBCA0
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 17 Jul 2007 02:21:33 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024)
	with ESMTP id 94126-07 for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 17 Jul 2007 02:21:23 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from py-out-1112.google.com (py-out-1112.google.com
 [64.233.166.180])
	by postgresql.org (Postfix) with ESMTP id 5BA779FBC9C
	for <pgsql-sql@postgresql.org>; Tue, 17 Jul 2007 02:21:24 -0300 (ADT)
Received: by py-out-1112.google.com with SMTP id d32so3092349pye
	for <pgsql-sql@postgresql.org>; Mon, 16 Jul 2007 22:21:21 -0700 (PDT)
DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta;
	h=domainkey-signature:received: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=dFUc7rICxePXnc6CXLxb8SC+Tvr+4oduhbNvnysKH7OiFmLMVdaqIhVZ719MTLsbKgBro/YYxiYXSTeAHySjjMQaepSZVFGQMT0pjxI58zBLZV6oWj6nx08wZF5NO43wcczRgak43De3bAEjilOr89K38j/lC8GrUswz4uC4mcM=
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=
Received: by 10.141.155.5 with SMTP id h5mr13726rvo.1184649680707;
	Mon, 16 Jul 2007 22:21:20 -0700 (PDT)
Received: from bitdldt04 ( [122.163.227.177])
	by mx.google.com with ESMTP id c36sm18797126rvf.2007.07.16.22.21.17
	(version=SSLv3 cipher=RC4-MD5); Mon, 16 Jul 2007 22:21:19 -0700 (PDT)
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
X-Mailer: Microsoft Office Outlook 12.0
Thread-Index: AcfHrothrQb+WgNdRzubxQc1sXV9mgAgrkeQ
Content-Language: en-us
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200707/96
X-Sequence-Number: 28831

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




From sql4-en@narod.ru Fri Jul  27 08:48:51 2007
Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id 75F1C9FB30C
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 27 Jul 2007 05:48:51 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024)
	with ESMTP id 90350-02 for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 27 Jul 2007 05:48:46 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from smtp3.yandex.ru (smtp3.yandex.ru [213.180.200.14])
	by postgresql.org (Postfix) with ESMTP id 8E5C29FB2D8
	for <pgsql-sql@postgresql.org>; Fri, 27 Jul 2007 05:48:45 -0300 (ADT)
Received: from dial-up.82.209.218.35.grodno.by ([82.209.218.35]:58865 "EHLO
	asu2.mshome.net" smtp-auth: "sql4-en" TLS-CIPHER: <none> TLS-PEER-CN1:
	<none>) by mail.yandex.ru with ESMTP id S4747716AbXG0Isj (ORCPT
	<rfc822;pgsql-sql@postgresql.org>); Fri, 27 Jul 2007 12:48:39 +0400
X-Comment: RFC 2476 MSA function at smtp3.yandex.ru logged sender identity as:
	sql4-en
Date: Fri, 27 Jul 2007 09:40:13 +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: <467967778.20070727094013@narod.ru>
To: pgsql-sql@postgresql.org
Subject: Re: calling webservice through postgresql function
In-Reply-To: <002e01c7c831$f2b61380$d8223a80$@com>
References: <00b101c7c51d$7754fb50$65fef1f0$@com>
	<414476065.20070716161857@narod.ru>
	<002e01c7c831$f2b61380$d8223a80$@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=1.361 tagged_above=0 required=5 tests=AWL=-0.139,
	BAYES_50=0.001, URIBL_SBL=1.499
X-Spam-Level: *
X-Archive-Number: 200707/167
X-Sequence-Number: 28902

Good day, Jyoti.

JS> we can use any of the "untrusted" procedural languages
JS> http://www.pgsql.cz/index.php/PL/Perlu_-_Untrusted_Perl_(en)
What !! There is no need to have
   CREATE OR REPLACE FUNCTION
   open FILE, $_[0]; my @cntn = ();
   while (<FILE>) { }
   
  __You as man (by hands) convert__ tree of data into database tables
by procedural language once again.
You are wrong: all, which is necessary, is to have __a.b.c__ in language for
JS> create table a (
JS>   id   num      primary key,
JS>   data float
JS> );
JS> create table b (
JS>   id   num      primary key,
JS>   ref  num      references a(id),
JS>   data float
JS> );
JS> create table c (
JS>   id   num      primary key,
JS>   link num      references b(id),
JS>   data float
JS> );

JS>  to access resources outside the database
JS> (e.g. pl/perlu).
There is no need to have
   CREATE OR REPLACE FUNCTION
   use DBI;
   my $dbh = DBI->connect('dbi:mysql:'.$_[0],$_[1],$_[2], 
      { RaiseError => 1, AutoCommit = > });

  __You as man (by hands) install connect__ between DBMS and external world
by procedural language once again.
You are 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)  http://html6.by.ru
Unicode2  (2.0.0)  http://unicode2.chat.ru
Computer2 (2.0.3)  http://computer20.chat.ru




From sql4-en@narod.ru Tue Jul  31 13:07:09 2007
Received: from localhost (maia-5.hub.org [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id B97179FA110
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 31 Jul 2007 10:07:09 -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 80932-05 for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 31 Jul 2007 10:07:01 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from smtp2.yandex.ru (smtp2.yandex.ru [213.180.200.18])
	by postgresql.org (Postfix) with ESMTP id B40459FA1BF
	for <pgsql-sql@postgresql.org>; Tue, 31 Jul 2007 10:07:05 -0300 (ADT)
Received: from dial-up.82.209.218.6.grodno.by ([82.209.218.6]:13045 "EHLO
	asu2.mshome.net" smtp-auth: "sql4-en" TLS-CIPHER: <none> TLS-PEER-CN1:
	<none>) by mail.yandex.ru with ESMTP id S4395501AbXGaNG4 (ORCPT
	<rfc822;pgsql-sql@postgresql.org>); Tue, 31 Jul 2007 17:06:56 +0400
X-Comment: RFC 2476 MSA function at smtp2.yandex.ru logged sender identity as:
	sql4-en
Date: Tue, 31 Jul 2007 16:08:23 +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: <125615350.20070731160823@narod.ru>
To: pgsql-sql@postgresql.org
Subject: Re: calling webservice through postgresql function
In-Reply-To: <467967778.20070727094013@narod.ru>
References: <00b101c7c51d$7754fb50$65fef1f0$@com>
	<414476065.20070716161857@narod.ru>
	<002e01c7c831$f2b61380$d8223a80$@com>
	<467967778.20070727094013@narod.ru>
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=2.185 tagged_above=0 required=5 tests=AWL=-0.958,
	BAYES_50=0.001, RCVD_IN_NJABL_PROXY=1.643, URIBL_SBL=1.499
X-Spam-Level: **
X-Archive-Number: 200707/196
X-Sequence-Number: 28931

Good day, Jyoti.

JS>> (e.g. pl/perlu).
DT>   __You as man (by hands) install connect__ between DBMS and external world
DT> by procedural language once again.
DT> You are wrong once again:
DT> advantage is to __refuse__ from procedural language (to install connect)
DT> instead of put it from outside of DBMS into inside of DBMS.
DT> All, which is necessary, is DBMS itself listen some port/protocol.

My version:

(1.1)
User send to remote database (HTTP will ask login):
c:/dir>  xml2http.exe database.my.com username password a.xml
for example
c:/dir>  dbf2xml.exe a.dbf | xml2http.exe database.my.com username password

(1.2)
User send to local database (at transformation data between DBMS-s):
c:/dir>  xml2http.exe 127.0.0.1 username password a.xml
for example
c:/dir>  dbf2xml.exe a.dbf | xml2http.exe 127.0.0.1 username password

(2.1)
Database send to local file (at transformation data between DBMS-s):
pg>      copy a.b.c to filename.xml;

(2.2)
Database send to remote database
(if 'sys.username' and 'sys.password' are equal null,
then database sends as anonymous):
pg>      update sys set
pg>        ral="database.remote.com",
pg>        username=
pg>        password= ;
pg>      a.b.c ->;
or
pg>      update sys set
pg>        ran="101.102.103.104",
pg>        username=
pg>        password= ;
pg>      a.b.c ->;
or if you prefer to export per table
pg>      update sys set ral="database.remote.com";
pg>      create view av as select * from a where ...
pg>      create view bv as select * from b where ...
pg>      create view cv as select * from c where ...
pg>      av ->;
pg>      bv ->;
pg>      cv ->;


Once again: users 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 you understand me ?


Dmitry Turin
SQL4      (4.1.3)  http://sql40.chat.ru
HTML6     (6.3.0)  http://html6.by.ru
Unicode2  (2.0.1)  http://unicode2.chat.ru
Computer2 (2.0.3)  http://computer20.chat.ru