Received: from uno.tksoft.com (modem-4.copernicus.brandx.net [209.55.65.4]) by hub.org (8.9.3/8.9.3) with ESMTP id SAA33262 for ; Fri, 16 Jul 1999 18:24:05 -0400 (EDT) (envelope-from tk@uno.tksoft.com) Received: (from tk@localhost) by uno.tksoft.com (8.8.8/8.8.8) id PAA14483 for pgsql-sql@postgreSQL.org; Fri, 16 Jul 1999 15:24:05 -0700 From: "tjk@tksoft.com" Message-Id: <199907162224.PAA14483@uno.tksoft.com> Subject: user defined function speeds To: pgsql-sql@postgreSQL.org Date: Fri, 16 Jul 1999 15:24:05 -0700 (PDT) In-Reply-To: from "Michael Richards" at Jul 16, 99 06:19:58 pm Content-Type: text > > Good plan. Although you could sort by a user-defined function result, > > it's likely to be horribly slow (because user-defined functions are > > slow:-(). What is the actual overhead from using a userdefined function (a C function, say)? Obviously there is an overhead involved in calling any function. I would like to know what kind of issues are involved when using results of a user defined function for sorting. Are the results calculated only once, as one would expect, for example. Thanks, Troy Troy Korjuslommi Tksoft OY, Inc. tjk@tksoft.com Software Development Open Source Solutions Hosting Services