Brian Hirt <bhirt@mobygames.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