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