Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id D313C63425F
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu, 27 Aug 2009 12:28:30 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 14553-02 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu, 27 Aug 2009 15:28:16 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from out01.mta.xmission.com (out01.mta.xmission.com [166.70.13.231])
	by mail.postgresql.org (Postfix) with ESMTP id 065476359E0
	for <pgsql-sql@postgresql.org>; Thu, 27 Aug 2009 12:28:03 -0300 (ADT)
Received: from in02.mta.xmission.com ([166.70.13.52])
	by out01.mta.xmission.com with esmtp (Exim 4.62)
	(envelope-from <robjsargent@gmail.com>)
	id 1Mggtg-0000hS-3D; Thu, 27 Aug 2009 09:28:20 -0600
Received: from [208.187.158.94] (helo=[172.16.1.221])
	by in02.mta.xmission.com with esmtpsa (TLSv1:AES256-SHA:256)
	(Exim 4.69) (envelope-from <robjsargent@gmail.com>)
	id 1MggtO-0005Gw-Ng; Thu, 27 Aug 2009 09:28:03 -0600
Message-ID: <4A96A5FC.6080604@gmail.com>
Date: Thu, 27 Aug 2009 09:27:56 -0600
From: Rob Sargent <robjsargent@gmail.com>
User-Agent: Thunderbird 2.0.0.23 (X11/20090817)
MIME-Version: 1.0
To: rawi <only4com@web.de>
CC: pgsql-sql@postgresql.org
Subject: Re: resolved: WITH RECURSIVE: ARRAY[id] All column datatypes
	must be hashable
References: <25167538.post@talk.nabble.com> <25168751.post@talk.nabble.com>
In-Reply-To: <25168751.post@talk.nabble.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-XM-SPF: eid=; ; ; mid=; ; ; hst=in02.mta.xmission.com; ; ;
 ip=208.187.158.94;
	; ; frm=robjsargent@gmail.com; ; ; spf=neutral
X-SA-Exim-Connect-IP: 208.187.158.94
X-SA-Exim-Rcpt-To: only4com@web.de, pgsql-sql@postgresql.org,
	robjsargent@gmail.com
X-SA-Exim-Mail-From: robjsargent@gmail.com
X-SA-Exim-Version: 4.2.1 (built Thu, 25 Oct 2007 00:26:12 +0000)
X-SA-Exim-Scanned: No (on in02.mta.xmission.com); Unknown failure
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.11 tagged_above=-10 required=5 tests=BAYES_05=-1.11
X-Spam-Level: 
X-Archive-Number: 200908/140
X-Sequence-Number: 33049

In so much as id-ma-pa is near and dear to my heart, I would really 
appreciate and performance metrics you might be able to share. 
Especially size of person table, typical pedigree size and pedigree 
retrieval time (tainted by hardware specs of course).

Thanks

rjs



rawi wrote:
> me again...
>
> I figured it out...
>
> The Error was caused because I used UNION in place of UNION ALL.
>
> I still don't understand why the ARRAY (path) could not be grouped...
>
> Bye
> rawi
>