Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cQcHo-0003oW-6p for pgsql-sql@arkaria.postgresql.org; Mon, 09 Jan 2017 15:55:04 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cQcHn-0002DL-3s for pgsql-sql@arkaria.postgresql.org; Mon, 09 Jan 2017 15:55:03 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cQcGo-00017c-5w for pgsql-sql@postgresql.org; Mon, 09 Jan 2017 15:54:02 +0000 Received: from mail-pf0-x232.google.com ([2607:f8b0:400e:c00::232]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1cQcGg-00035d-Uy for pgsql-sql@postgresql.org; Mon, 09 Jan 2017 15:54:00 +0000 Received: by mail-pf0-x232.google.com with SMTP id y143so10928747pfb.0 for ; Mon, 09 Jan 2017 07:53:54 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-transfer-encoding; bh=Ff1HQQoGbfs4T7F74d6k7K53J/ItEP1dZngEzanWe+U=; b=Uv78l48ghtVWeJXkQOIvNF8prwKnpru+V4YNmzUDizACiPLqCM/lxMYRXEJg05FtzS Y8EXxhPwgn5w++xsXBv7aM3j9gcwa6yosEWHr28ldQn6RMduLg6EOKvP/uFOVNojoQyV qj9uh9r3NcWvitekcFsZDJsen+IVGW2x34P+hZqVOjZjmARahJjxeEF5skQxNbCI85dg +241aPiV2NLDT7liPXlGRuh28HrPyYbFI6ZbfQIP8H8skmlrh8EZd0Amc/Fd0AR2QxHN SymAjKvZ85GDakqkEPobzKdmHO+t3nKqFndOXKo5hUk1yGsAXJ4mAWSAWhA9L7qXrm8q vlvQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding; bh=Ff1HQQoGbfs4T7F74d6k7K53J/ItEP1dZngEzanWe+U=; b=SByb2K0v415cclM9jIyiUgUe25V+sy3S6rMI3OeWCNnhTM42h3A6WMIdES1rCjMBer 9QMTX/S1bYQ/gEeJsdVSCgTDQDzvvl7dNad9UQNRlre7IHodN0DsSjBVXHTZvpSxEswQ 7DJ8S/WRzBKPBpZkxNELXfV1wXMBldcZjx1aeYYkUtItVXuZsevp0LdGlOHV/dl8LRWY Heaq9Ssy4WB3O7oHiXd+Y3GHXdgDN0ICoDjWfgRPHBaMFkMc9/Np73BQmCHTJckTEVg6 CR0jKkMpb5iF20sY1/SYvMhDJ3FyhFfUMvzmhzMPj3dLCDCAgiKUreuGkHXHLE4p0qm3 cBpg== X-Gm-Message-State: AIkVDXLuDxFn0/33wIGYMH7ht52ASlc/qQ7083RZfq1IY8jxuNA85Yv4KWgZol0SofjDZA== X-Received: by 10.84.216.24 with SMTP id m24mr188952364pli.22.1483977233458; Mon, 09 Jan 2017 07:53:53 -0800 (PST) Received: from [155.100.214.120] ([155.100.214.120]) by smtp.gmail.com with ESMTPSA id r78sm10119624pfe.55.2017.01.09.07.53.51 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Mon, 09 Jan 2017 07:53:52 -0800 (PST) Subject: Re: How to use external java libraries in Database To: pgsql-sql@postgresql.org References: <1483960853041-5938143.post@n3.nabble.com> From: Rob Sargent Message-ID: Date: Mon, 9 Jan 2017 08:54:00 -0700 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Thunderbird/45.4.0 MIME-Version: 1.0 In-Reply-To: <1483960853041-5938143.post@n3.nabble.com> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org On 01/09/2017 04:20 AM, bb23850 wrote: > 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. > > https://tada.github.io/pljava/ -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql