Received: from frosch.all.de (mail.beehive.de [212.21.71.35]) by hub.org (8.9.3/8.9.3) with ESMTP id UAA09758 for ; Fri, 22 Oct 1999 20:00:40 -0400 (EDT) (envelope-from guenther@laokoon.IN-Berlin.DE) Received: by mail.beehive.de (8.9.3/nora-19990817) with UUCP for pgsql-sql@hub.org (envelope-from guenther@laokoon.IN-Berlin.DE) id CAA83962; Sat, 23 Oct 1999 02:00:28 +0200 (CEST) Received: (from guenther@localhost) by laokoon.bug.net (8.9.3/8.9.3) id BAA11750 for pgsql-sql@hub.org; Sat, 23 Oct 1999 01:34:51 +0200 Message-Id: <199910222334.BAA11750@laokoon.bug.net> Subject: sum-function To: pgsql-sql@hub.org Date: Sat, 23 Oct 1999 01:34:51 +0200 (CEST) X-Charset: ISO-8859-1 From: guenther@laokoon.IN-Berlin.DE (Christian Guenther) X-Mailer: ELM [version 2.4 PL25] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Hello, I like to use udmsearch with postgresql, but for searching I need a funktion like the following. Every time I get an error. Is there a possibility to make a work around? udmsearch=> select sum( dict.word = 'mysql') from dict\g ERROR: Unable to select an aggregate function sum(bool) What does the ERROR mean. Thanks for any hint. Christian P.S. Sorry about the terrible English. -- Christian Guenther Kunsthistoriker Fax: +49 030 4464152 E-mail: cg@kunst-und-kultur.de Tel: +49 030 4442931 http://kunst-und-kultur.de/ Museen, Kuenstler, Ausstellungen, Kunstprojekte ....