Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: resolved: WITH RECURSIVE: ARRAY[id] All column datatypes must be hashable
Date
Msg-id 3854.1251386282@sss.pgh.pa.us
Whole thread Raw
In response to resolved: WITH RECURSIVE: ARRAY[id] All column datatypes must be hashable  (rawi <only4com@web.de>)
Responses hopeless, SQL not resolved yet  (rawi <only4com@web.de>)
Re: resolved: WITH RECURSIVE: ARRAY[id] All column datatypes must be hashable  (Will Furnass <will@thearete.co.uk>)
List pgsql-sql
Tree view 
rawi <only4com@web.de> writes:
> 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...

Yeah, it's an unimplemented feature --- there's no hashing support for
arrays.  I hope to get that done for 8.5.  In the meantime you have
to use UNION ALL there.  If you really need to eliminate duplicate
rows, you can do that via DISTINCT in the outer query.
        regards, tom lane

pgsql-sql by date:

Previous
From: rawi
Date:
Subject: resolved: WITH RECURSIVE: ARRAY[id] All column datatypes must be hashable
Next
From: Rob Sargent
Date:
Subject: Re: resolved: WITH RECURSIVE: ARRAY[id] All column datatypes must be hashable