Re: resolved: WITH RECURSIVE: ARRAY[id] All column datatypes must be hashable - Mailing list pgsql-sql

From Rob Sargent
Subject Re: resolved: WITH RECURSIVE: ARRAY[id] All column datatypes must be hashable
Date
Msg-id 4A96A5FC.6080604@gmail.com
Whole thread Raw
In response to resolved: WITH RECURSIVE: ARRAY[id] All column datatypes must be hashable  (rawi <only4com@web.de>)
List pgsql-sql
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
>   


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: resolved: WITH RECURSIVE: ARRAY[id] All column datatypes must be hashable
Next
From: Nathaniel Smith
Date:
Subject: Data audit trail techniques in postgresql