Re: calling webservice through postgresql function

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