Re: resolved: WITH RECURSIVE: ARRAY[id] All column datatypes must be hashable

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: rawi <only4com(at)web(dot)de>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: resolved: WITH RECURSIVE: ARRAY[id] All column datatypes must be hashable
Date: 2009-08-27 15:27:56
Message-ID: 4A96A5FC.6080604@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
>

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Nathaniel Smith 2009-08-27 16:28:31 Data audit trail techniques in postgresql
Previous Message Tom Lane 2009-08-27 15:18:02 Re: resolved: WITH RECURSIVE: ARRAY[id] All column datatypes must be hashable