[GENERAL] non-btree primary key

2006-02-25 Thread Roman Neuhauser
Hello, looks like PostgreSQL (8.0/8.1) has no support for using other-than-btree indexes for primary keys. Is there a (perhaps un(der)documented) way to specify the index type? Rationale: I'm trying to have PKs on a type that defines only the = and <> operators, and would work with a hash-based P

Re: [GENERAL] non-btree primary key

2006-02-25 Thread Tom Lane
Roman Neuhauser <[EMAIL PROTECTED]> writes: > looks like PostgreSQL (8.0/8.1) has no support for using > other-than-btree indexes for primary keys. Is there a (perhaps > un(der)documented) way to specify the index type? No --- at present this is not possible because btree is the only index type th