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 34D979FA103 for ; Wed, 13 Sep 2006 18:13:14 -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 02817-08 for ; Wed, 13 Sep 2006 21:13:11 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 02D859FA0EF for ; Wed, 13 Sep 2006 18:13:10 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k8DLD7YT016723; Wed, 13 Sep 2006 17:13:07 -0400 (EDT) To: Markus Schaber cc: PostgreSQL SQL List Subject: Re: Aggregates with internal state type? In-reply-to: <45086B40.3000200@logix-tt.com> References: <45086B40.3000200@logix-tt.com> Comments: In-reply-to Markus Schaber message dated "Wed, 13 Sep 2006 22:34:08 +0200" Date: Wed, 13 Sep 2006 17:13:07 -0400 Message-ID: <16722.1158181987@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200609/91 X-Sequence-Number: 26302 Markus Schaber writes: > 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. No, because the system has no idea what the representation of an "internal" state value might be, and in particular how to copy it. The same goes for other pseudotypes. regards, tom lane