Re: WITH RECURSIVE ... CYCLE in vanilla SQL: issues with arrays of rows

"Merlin Moncure" <mmoncure(at)gmail(dot)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