X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 7B5D19F9F7E for ; Wed, 13 Sep 2006 17:34:18 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 99781-05 for ; Wed, 13 Sep 2006 20:34:10 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.logix-tt.com (mail.logix-tt.com [212.211.145.186]) by postgresql.org (Postfix) with ESMTP id F01D89F9F7D for ; Wed, 13 Sep 2006 17:34:09 -0300 (ADT) Received: from kingfisher.intern.logix-tt.com (p549D1F34.dip0.t-ipconnect.de [84.157.31.52]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.logix-tt.com (Postfix) with ESMTP id 280F965978 for ; Wed, 13 Sep 2006 22:36:24 +0200 (CEST) Received: from [127.0.0.1] (localhost [127.0.0.1]) by kingfisher.intern.logix-tt.com (Postfix) with ESMTP id 492961809DD31 for ; Wed, 13 Sep 2006 22:34:08 +0200 (CEST) Message-ID: <45086B40.3000200@logix-tt.com> Date: Wed, 13 Sep 2006 22:34:08 +0200 From: Markus Schaber Organization: Logical Tracking and Tracing International AG, Switzerland User-Agent: Thunderbird 1.5.0.5 (X11/20060812) MIME-Version: 1.0 To: PostgreSQL SQL List Subject: Aggregates with internal state type? X-Enigmail-Version: 0.94.0.0 Content-Type: text/plain; charset=ISO-8859-15 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.135 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200609/90 X-Sequence-Number: 26301 Hi, The PostgreSQL allows functions to define "internal" as parameter and return types for functions, when those are not visible from SQL. This lead me to the question whether it is possible to use "internal" as state type for an Aggregate whose functions are implemented in C. Thanks, Markus -- Markus Schaber | Logical Tracking&Tracing International AG Dipl. Inf. | Software Development GIS Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org