Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from
 <pgsql-sql-owner+M38999=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
	id 1cQadn-0006sz-1K
	for pgsql-sql@arkaria.postgresql.org; Mon, 09 Jan 2017 14:09:39 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.84_2)
	(envelope-from
 <pgsql-sql-owner+M38999=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
	id 1cQadm-0004DL-KT
	for pgsql-sql@arkaria.postgresql.org; Mon, 09 Jan 2017 14:09:38 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <bb23850@gmail.com>)
	id 1cQY0Z-0007S5-DC
	for pgsql-sql@postgresql.org; Mon, 09 Jan 2017 11:20:59 +0000
Received: from mwork.nabble.com ([162.253.133.43])
	by magus.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from <bb23850@gmail.com>)
	id 1cQY0U-0006pR-Iq
	for pgsql-sql@postgresql.org; Mon, 09 Jan 2017 11:20:58 +0000
Received: from mben.nabble.com (unknown [162.253.133.72])
	by mwork.nabble.com (Postfix) with ESMTP id 39690F7F0125
	for <pgsql-sql@postgresql.org>; Mon,  9 Jan 2017 04:20:53 -0700 (MST)
Date: Mon, 9 Jan 2017 04:20:53 -0700 (MST)
From: bb23850 <bb23850@gmail.com>
To: pgsql-sql@postgresql.org
Message-ID: <1483960853041-5938143.post@n3.nabble.com>
Subject: How to use external java libraries in Database
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -0.1 (/)
List-Archive: <http://archives.postgresql.org/pgsql-sql>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-sql.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@postgresql.org>
List-Post: <mailto:pgsql-sql@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-sql>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
X-Mailing-List: pgsql-sql
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

Hi,

I am trying to use Apache.Commons or Cern Colt libraries in my database.
Both these libraries are written Java and are available as .jar files. Is it
possible to pull those libraries into Postgres and use the methods in SQL as
functions.

For example I want to use cern.jet.stat.Descriptive.harmonicMean in SQL as
follows:

select harmonicMean(100, 1000);

Please suggest me how to do this.

thanks and regards

BB23850



--
View this message in context: http://postgresql.nabble.com/How-to-use-external-java-libraries-in-Database-tp5938143.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql