union in an in clause and timestamp

From: Brian Hirt <bhirt(at)mobygames(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Cc: Brian Hirt <bhirt(at)loopy(dot)berkhirt(dot)com>
Subject: union in an in clause and timestamp
Date: 2000-02-01 07:48:54
Message-ID: 20000201014854.A10211@loopy.berkhirt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Okay, I'm running into two things that I would expect to work.
I've included a simple test case for both to reproduce the problem.

1) Obviously, the first two work and the third does not.
are these bugs?

2) Cannot create index on timestamp colmun

basement=> select version();
version
-------------------------------------------------------------------
PostgreSQL 6.5.2 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66
(1 row)
basement=> select 'hello' where 1 in (select 1);
?column?
--------
hello
(1 row)
basement=> select 'hello' where 1 in (select 2);
?column?
--------
(0 rows)
basement=> select 'hello' where 1 in (select 2 union select 1);
ERROR: parser: parse error at or near "union"
basement=>

And then, I find that I cannot create an index on a
timestamp column;

basement=> create table ts (t timestamp);
CREATE
basement=> create index ttt on ts(t);
ERROR: Can't find a default operator class for type 1296.
basement=>

--
The world's most ambitious and comprehensive PC game database project.

http://www.mobygames.com

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Chris 2000-02-01 08:36:25 majordomo
Previous Message Don Baccus 2000-02-01 05:09:28 Re: [HACKERS] Re: Case-folding bogosity in new psql