Received: from flex.flex.ro (IDENT:root@[193.230.255.4]) by hub.org (8.9.3/8.9.3) with ESMTP id IAA45916 for ; Sat, 28 Aug 1999 08:10:35 -0400 (EDT) (envelope-from teo@flex.ro) Received: from flex.ro (IDENT:teo@teo.flex.ro [193.230.255.3]) by flex.flex.ro (8.9.3/8.9.3) with ESMTP id PAA14666 for ; Sat, 28 Aug 1999 15:11:44 +0300 Sender: teo@flex.flex.ro Message-ID: <37C7D355.F6F1DA5C@flex.ro> Date: Sat, 28 Aug 1999 12:17:25 +0000 From: Constantin Teodorescu Organization: FLEX Consulting Braila X-Mailer: Mozilla 4.61 [en] (X11; I; Linux 2.2.11 i586) X-Accept-Language: en MIME-Version: 1.0 To: PostgreSQL Interfaces Subject: Need an example - more information Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit The function should run on the server (installed with CREATe FUNCTION command) as in the example : select product, price, getcomplexinformation(product) from stock; The getcomplexinformation function will search over other 3 tables, compute some intense math operations on them and return a result. I have experimented with plpgsql and pltcl but I will need more speed. Thanks again, -- Constantin Teodorescu FLEX Consulting Braila, ROMANIA