Re: WITH RECURSIVE ... CYCLE in vanilla SQL: issues with arrays of rows - Mailing list pgsql-hackers

From Tom Lane
Subject Re: WITH RECURSIVE ... CYCLE in vanilla SQL: issues with arrays of rows
Date
Msg-id 9941.1223903425@sss.pgh.pa.us
Whole thread Raw
In response to Re: WITH RECURSIVE ... CYCLE in vanilla SQL: issues with arrays of rows  ("Merlin Moncure" <mmoncure@gmail.com>)
Responses Re: WITH RECURSIVE ... CYCLE in vanilla SQL: issues with arrays of rows
List pgsql-hackers
"Merlin Moncure" <mmoncure@gmail.com> writes:
> The record ops work as promised.  IMO this patch stands in its own
> merits with or without the CTE changes.  I played around with it and
> noticed a couple of oddities:

> select foo = foo from foo;  --works
> but

> select distinct foo from foo; --yields
> ERROR:  could not identify an equality operator for type foo
> also,

> select foo from foo order by foo;
> ERROR:  could not identify an ordering operator for type foo

Yeah, these are because of the incomplete handling of named record
types.  I'm not sure how far we want to go in that direction.

> postgres=# create index foo_idx on foo((foo));
> ERROR:  cache lookup failed for type 0

Hm, that's not good ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: out-of-date comment in auto-generated oidjoins.sql
Next
From: Zdenek Kotala
Date:
Subject: Re: [PATCH] Extending pg_class info + more flexible TOAST chunk size