Re: [HACKERS] union in an in clause and timestamp

Brian Hirt <bhirt(at)mobygames(dot)com> writes:
> Okay, I'm running into two things that I would expect to work.

> basement=> select 'hello' where 1 in (select 2 union select 1);
> ERROR: parser: parse error at or near "union"

UNION isn't currently supported in sub-selects. Hopefully we can make
it work after the long-threatened querytree redesign. But right now,
the union code is so crufty that no one wants to touch it...

> And then, I find that I cannot create an index on a
> timestamp column;
> basement=> create index ttt on ts(t);
> ERROR: Can't find a default operator class for type 1296.

For the moment, use one of the other time-related types instead.
After the dust settles from Thomas' upcoming consolidation of the
date/time datatypes, I expect everything that remains will have a
complete set of operators and index support.

regards, tom lane